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

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"