Database: ship_1
Question: How many captains are in each rank?
SQL:
SELECT count(*) ,  rank FROM captain GROUP BY rank