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
male architects = WHERE gender = 'male'; ordered by their names lexicographically = ORDER BY name ASC; list name, nationality, id = SELECT name, nationality, id;