CREATE TABLE ship (ship_id DECIMAL, name TEXT, type TEXT, nationality TEXT, tonnage DECIMAL)
CREATE TABLE mission (mission_id DECIMAL, ship_id DECIMAL, code TEXT, launched_year DECIMAL, location TEXT, speed_knots DECIMAL, fate TEXT)

What are the names of the ships that are from either the US or the UK?
SELECT name FROM ship WHERE nationality = "United States" OR nationality = "United Kingdom"
SELECT "name" FROM "ship" WHERE "United Kingdom" = "nationality" OR "United States" = "nationality"