CREATE TABLE Faculty (Sex VARCHAR2, Rank VARCHAR2)

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