CREATE TABLE ship (ship_id DECIMAL, name TEXT, type TEXT, built_year DECIMAL, class TEXT, flag TEXT)
CREATE TABLE captain (captain_id DECIMAL, name TEXT, ship_id DECIMAL, age TEXT, class TEXT, rank TEXT)

Count the number of captains that have each rank.
SELECT COUNT(*), rank FROM captain GROUP BY rank
SELECT COUNT(*), "rank" FROM "captain" GROUP BY "rank"