Show the rank for all faculty members.
select rank from faculty
For each of them, show the number of faculty members.
select rank, count(*) from faculty group by rank