List the names and nationalities of all architects.
select name, nationality from architect
Include their ids as well.
select name, nationality, id from architect
Only include architects who are male.
select name, nationality, id from architect where gender = "male"
List the names alphabetically.
select name, nationality, id from architect where gender = "male" order by name