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
Show me the name of all the ships.
assistant
SELECT name FROM ship;
human
Which of them belong to United states?
assistant
SELECT Name FROM ship WHERE Nationality = "United States" ;