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