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)

Find the name, class and rank of all captains.
SELECT name, class, rank FROM captain
SELECT "name", "class", "rank" FROM "captain"