CREATE TABLE mission (Fate VARCHAR2, Ship_ID VARCHAR2)
CREATE TABLE ship (Ship_ID VARCHAR2, Nationality VARCHAR2)

Show the distinct fate of missions that involve ships with nationality '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"
SELECT DISTINCT "T1"."Fate" FROM "mission" "T1" JOIN "ship" "T2" ON "T1"."Ship_ID" = "T2"."Ship_ID" AND "T2"."Nationality" = "United States"