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
What are the name of all the ships?
assistant
SELECT NAME FROM ship;
human
Give me missions that were launched after 1928.
assistant
SELECT * FROM Mission WHERE Launched_Year > 1928;
human
Which ships were involved in any of those?
assistant
SELECT T2.Name FROM mission AS T1 JOIN ship AS T2 ON T1.Ship_ID = T2.Ship_ID WHERE T1.Launched_Year > 1928 ;