For each faculty rank, show the number of faculty members who have it.
select rank, count(*) from faculty group by rank