Table schema:
CREATE TABLE captain (rank VARCHAR)

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