CREATE TABLE mission (Fate VARCHAR(255), Ship_ID VARCHAR(255)); CREATE TABLE ship (Ship_ID VARCHAR(255), Nationality VARCHAR(255))
Show the distinct fate of missions that involve ships with nationality "United States"
    
SQL: SELECT DISTINCT T1.Fate FROM mission AS T1 JOIN ship AS T2 ON T1.Ship_ID = T2.Ship_ID WHERE T2.Nationality = "United States"