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

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" AS "T1" JOIN "ship" AS "T2" ON "T1"."Ship_ID" = "T2"."Ship_ID" AND "T2"."Nationality" = "United States"