List the name of ships that are not involved in any mission
CREATE TABLE mission (Name VARCHAR, Ship_ID VARCHAR); CREATE TABLE ship (Name VARCHAR, Ship_ID VARCHAR)
[SQL] SELECT Name FROM ship WHERE NOT Ship_ID IN (SELECT Ship_ID FROM mission) [/SQL]