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