question: What country had an anti-ship missile that had a solid rocket propulsion?
answer: SELECT country FROM table_name_96 WHERE propulsion = "solid rocket"
context: CREATE TABLE table_name_96 (country VARCHAR, propulsion VARCHAR)