Database: architecture
Question: How many architects are female?
SQL:
SELECT count(*) FROM architect WHERE gender  =  'female'