CREATE TABLE mission (mission_id NUMBER, ship_id NUMBER, code CLOB, launched_year NUMBER, location CLOB, speed_knots NUMBER, fate CLOB)
CREATE TABLE ship (ship_id NUMBER, name CLOB, type CLOB, nationality CLOB, tonnage NUMBER)

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"
SELECT DISTINCT "T1"."fate" FROM "mission" "T1" JOIN "ship" "T2" ON "T1"."ship_id" = "T2"."ship_id" AND "T2"."nationality" = "United States"