How many faculty are there?
select count(*) from faculty
What about female ones?
select count(*) from faculty where sex = 'F'
What about female professors?
select count(*) from faculty where sex = 'F' and rank = "Professor"