Can you please show me the names of all male architects by their names lexicographically?
SELECT name FROM architect WHERE gender  =  'male' ORDER BY name
names of all male architects = WHERE gender = 'male'; lexicographically = ORDER BY name ASC;