How many faculty members do we have for each rank and gender?
select rank, sex, count(*) from faculty group by rank, sex