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

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