What country had an anti-ship missile that had a solid rocket propulsion?
CREATE TABLE table_name_96 (country VARCHAR, propulsion VARCHAR)
SELECT country FROM table_name_96 WHERE propulsion = "solid rocket"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_96 (country VARCHAR, propulsion VARCHAR) Question: What country had an anti-ship missile that had a solid rocket propulsion? [/INST] SELECT country FROM table_name_96 WHERE propulsion = "solid rocket" </s>