What are all the missions?
select * from mission
Which ship is involved in any of them?
select ship_id from mission
Give me the name of ships which are not among those.
select name from ship where ship_id not in (select ship_id from mission)