CREATE TABLE table_name_47 (country VARCHAR(255), ship VARCHAR(255))
What Country is the John S. McCain Ship from?
    
SQL: SELECT country FROM table_name_47 WHERE ship = "john s. mccain"