SELECT count(*) FROM architect WHERE gender  =  'female'
How many architects are female?
SELECT count ( * ) FROM architect WHERE gender = 'female '
select count ( * ) from architect where gender = value
How many architects are female ?