Can you please list all the ranks and the number of male faculty members for those ranks?
select rank, sex, count ( * ) from faculty where sex = "M" group by rank, sex
Can you add the number of female faculty members for each of the ranks to the table please?
select rank, sex, count ( * ) from faculty group by rank, sex