CREATE TABLE mission (mission_id NUMBER, ship_id NUMBER, code CLOB, launched_year NUMBER, location CLOB, speed_knots NUMBER, fate CLOB)
CREATE TABLE ship (ship_id NUMBER, name CLOB, type CLOB, nationality CLOB, tonnage NUMBER)

What are the types and nationalities of every ship?
SELECT type, nationality FROM ship
SELECT "type", "nationality" FROM "ship"