Database: architecture
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