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


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