-- Database schema
| mission : Mission_ID [ INT ] primary_key , Ship_ID [ INT ] mission.Ship_ID = ship.Ship_ID , Code [ TEXT ] , Launched_Year [ INT ] , Location [ TEXT ] , Speed_knots [ INT ] , Fate [ TEXT ] | ship : Ship_ID [ INT ] primary_key , Name [ TEXT ] , Type [ TEXT ] , Nationality [ TEXT ] , Tonnage [ INT ] |
-- -- What are the different fates of the mission that involved ships from the United States?

SELECT DISTINCT T1.Fate FROM mission AS T1 JOIN ship AS T2 ON T1.Ship_ID  =  T2.Ship_ID WHERE T2.Nationality  =  "United States";