Database: activity_1
Question: How many male and female assistant professors do we have?
SQL:
SELECT sex ,  count(*) FROM Faculty WHERE rank  =  "AsstProf" GROUP BY sex