CREATE TABLE table_name_47 (country VARCHAR2, ship VARCHAR2)

What Country is the John S. McCain Ship from?
SELECT country FROM table_name_47 WHERE ship = "john s. mccain"
SELECT "country" FROM "table_name_47" WHERE "john s. mccain" = "ship"