Show all rank and sex for each faculty member.
select rank, sex from faculty
Show the counts of faculty grouped by both rank and sex.
select rank, sex, count(*) from faculty group by rank, sex