Show all the ranks and the number of male and female faculty for each rank.
select rank, sex, count(*) from faculty group by rank, sex