Schema: CREATE TABLE architect (name VARCHAR, nationality VARCHAR, id VARCHAR, gender VARCHAR)
Question: List the name, nationality and id of all male architects ordered by their names lexicographically.
SQL: SELECT name, nationality, id FROM architect WHERE gender = 'male' ORDER BY name