How many female Professors do we have?
CREATE TABLE Faculty (Sex VARCHAR, Rank VARCHAR)
SELECT COUNT(*) FROM Faculty WHERE Sex = 'F' AND Rank = "Professor"
### Context: CREATE TABLE Faculty (Sex VARCHAR, Rank VARCHAR) ### Question: How many female Professors do we have? ### Answer: SELECT COUNT(*) FROM Faculty WHERE Sex = 'F' AND Rank = "Professor"