Schema: CREATE TABLE architect (gender VARCHAR)
Question: How many architects are female?
SQL: SELECT COUNT(*) FROM architect WHERE gender = 'female'