human
Schema:
mission (Mission_ID, Ship_ID, Code, Launched_Year, Location, Speed_knots, Fate)
ship (Ship_ID, Name, Type, Nationality, Tonnage)
Please answer with SQL.
assistant
Sure, I understand.
human
How many ships are there?
assistant
SELECT COUNT( * ) FROM ship;
human
Which of them are from United States?
assistant
SELECT * FROM ship WHERE Nationality = 'United States';
human
Show me the distinct fate of missions that involve any of those.
assistant
SELECT DISTINCT T1.Fate FROM mission AS T1 JOIN ship AS T2 ON T1.Ship_ID = T2.Ship_ID WHERE T2.Nationality = "United States" ;