CREATE TABLE table_name_96 (country VARCHAR, propulsion VARCHAR)

What country had an anti-ship missile that had a solid rocket propulsion?
SELECT country FROM table_name_96 WHERE propulsion = "solid rocket"
SELECT "country" FROM "table_name_96" WHERE "propulsion" = "solid rocket"