SELECT rank ,  count(*) FROM Faculty GROUP BY rank
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
How many faculty members do we have for each faculty rank ?