Table 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