CREATE TABLE Faculty (rank VARCHAR, sex VARCHAR)

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
SELECT "rank", "sex", COUNT(*) FROM "Faculty" GROUP BY "rank", "sex"