Show the number of male and female assistant professors.
SELECT sex ,  count(*) FROM Faculty WHERE rank  =  "AsstProf" GROUP BY sex
SELECT sex ,  count(*) FROM Faculty WHERE rank  =  "AsstProf" GROUP BY sex
[{'Sex': 'F', 'count(*)': 3}, {'Sex': 'M', 'count(*)': 12}]