How many male and female assistant professors do we have?
select sex, count(*) from faculty where rank = "AsstProf" group by sex