Can you please show me all female architects by their names lexicographically?
SELECT name FROM architect WHERE gender  =  'male' ORDER BY name
all female architects refers to WHERE gender = 'female'; by their names lexicographically refers to ORDER BY name ASC (ascending is default and can be omitted for lexicographical order);