Return all the male architects.
select * from architect where gender = 'male'
What are their names, nationalities and ids?
select name, nationality, id from architect where gender = 'male'
Sort them by name.
select name, nationality, id from architect where gender = 'male' order by name