How many faculty members do we have for each faculty rank?
SELECT rank ,  count(*) FROM Faculty GROUP BY rank
SELECT rank ,  count(*) FROM Faculty GROUP BY rank
[{'Rank': 'AssocProf', 'count(*)': 8}, {'Rank': 'AsstProf', 'count(*)': 15}, {'Rank': 'Instructor', 'count(*)': 8}, {'Rank': 'Professor', 'count(*)': 27}]