Schema: CREATE TABLE Faculty (rank VARCHAR, sex VARCHAR)
Question: Show all the ranks and the number of male and female faculty for each rank.
SQL: SELECT rank, sex, COUNT(*) FROM Faculty GROUP BY rank, sex