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