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)

List the name of ships that are not involved in any mission
SELECT name FROM ship WHERE NOT ship_id IN (SELECT ship_id FROM mission)
SELECT "name" FROM "ship" WHERE NOT "ship_id" IN (SELECT "ship_id" FROM "mission")