Table schema:
CREATE TABLE architect (gender VARCHAR)

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