Database: activity_1
Question: Show the number of male and female assistant professors.
SQL:
SELECT sex ,  count(*) FROM Faculty WHERE rank  =  "AsstProf" GROUP BY sex