Show the sex for each Faculty member.
select sex from faculty
Show the result for only assistant professors.
select sex from faculty where rank = "AsstProf"
How many assistant professors are there of each sex?
select sex, count(*) from faculty where rank = "AsstProf" group by sex