Show the distinct fate of missions that involve ships with nationality "United States"
create table mission (fate varchar, ship_id varchar, PRIMARY KEY (fate)); create table ship (ship_id varchar, nationality varchar, PRIMARY KEY (ship_id))
select distinct t1.fate from mission as t1 join ship as t2 on t1.ship_id = t2.ship_id where t2.nationality = "united states"