How many professors are there?
select count ( * ) from faculty where rank = "Professor"
Well, yes.
select count ( * ) from faculty where rank = "AsstProf"
yes, how many are women?
select count ( * ) from faculty where rank = "AsstProf" and sex = "F"