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
Hello! How are you! Can you tell me how many missions there are in total?
assistant
SELECT COUNT( * ) FROM mission;
human
Great! Can you filter this list to show only the mission that involved ships from the United States?
assistant
SELECT T1.Fate FROM mission AS T1 JOIN ship AS T2 ON T1.Ship_ID = T2.Ship_ID WHERE T2.Nationality = "United States" ;