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

Count the number of different ranks of captain.
SELECT COUNT(DISTINCT rank) FROM captain
SELECT COUNT(DISTINCT "rank") FROM "captain"