Give me the names of ships that have been decommissioned
Select Name from ship 
where Ship_ID in  ( 
SELECT Ship_ID FROM mission WHERE Fate like '%Decommissioned%' ) 
names of ships that have been decommissioned refers to selecting Name from ship where related mission Fate includes 'Decommissioned';