SCHEMA:
CREATE TABLE architect (name VARCHAR, nationality VARCHAR, id VARCHAR, gender VARCHAR)
USER:
List the name, nationality and id of all male architects ordered by their names lexicographically.

QUERY:
SELECT name, nationality, id FROM architect WHERE gender = 'male' ORDER BY name