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