SELECT sex ,  count(*) FROM Faculty WHERE rank  =  "AsstProf" GROUP BY sex
How many male and female assistant professors do we have?
SELECT sex , count ( * ) FROM Faculty WHERE rank = `` AsstProf '' GROUP BY sex
select sex , count ( * ) from faculty where rank = value group by sex
How many male and female assistant professors do we have ?