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
[{'Rank': 'AssocProf', 'Sex': 'F', 'count(*)': 1}, {'Rank': 'AssocProf', 'Sex': 'M', 'count(*)': 7}, {'Rank': 'AsstProf', 'Sex': 'F', 'count(*)': 3}, {'Rank': 'AsstProf', 'Sex': 'M', 'count(*)': 12}, {'Rank': 'Instructor', 'Sex': 'F', 'count(*)': 3}, {'Rank': 'Instructor', 'Sex': 'M', 'count(*)': 5}, {'Rank': 'Professor', 'Sex': 'M', 'count(*)': 27}]