CREATE TABLE mission (Name VARCHAR, Ship_ID VARCHAR)
CREATE TABLE ship (Name VARCHAR, Ship_ID VARCHAR)

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")