SELECT Name FROM ship WHERE Ship_ID NOT IN (SELECT Ship_ID FROM mission)
List the name of ships that are not involved in any mission
SELECT Name FROM ship WHERE Ship_ID NOT IN ( SELECT Ship_ID FROM mission )
select name from ship where ship_id not in ( select ship_id from mission )
List the name of ships that are not involved in any mission