user: Question: What country had an anti-ship missile that had a solid rocket propulsion?
Columns: ['Name', 'Year', 'Propulsion', 'launched by', 'Country']
Types: ['text', 'real', 'text', 'text', 'text']
Sample row: ['Fritz X', 1943.0, 'none', 'Air', 'DE']
SQL:

assistant: SELECT "Country" FROM "Table" WHERE "Propulsion" = 'solid rocket';