Show the names of all ships from United Kingdom?
SELECT Name FROM ship WHERE Nationality   =   "United Kingdom"
names of all ships from United Kingdom refers to SELECT Name FROM ship WHERE Nationality = 'United Kingdom';