Database: activity_1
Question: Count the number of female Professors we have.
SQL:
SELECT count(*) FROM Faculty WHERE Sex  =  'F' AND Rank  =  "Professor"