SELECT count(*) ,  rank FROM captain GROUP BY rank
How many captains are in each rank?
SELECT count ( * ) , rank FROM captain GROUP BY rank
select count ( * ) , rank from captain group by rank
How many captains are in each rank ?