Table schema:
CREATE TABLE Faculty (Sex VARCHAR, Rank VARCHAR)

Question: How many female Professors do we have?
SQL: SELECT COUNT(*) FROM Faculty WHERE Sex = 'F' AND Rank = "Professor"