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