CREATE TABLE table_name_30 (ship VARCHAR2, location VARCHAR2)

Which ship was launched from Devonport, Devon?
SELECT ship FROM table_name_30 WHERE location = "devonport, devon"
SELECT "ship" FROM "table_name_30" WHERE "devonport, devon" = "location"