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
Can you please show me all female architects by their names lexicographically?
select name from architect where gender = 'male' order by name
can you please show me all the female architects?
select name from architect where gender = 'male'
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