What country had an anti-ship missile that had a solid rocket propulsion?
CREATE TABLE "comparison" (
  "name" text,
  "year" real,
  "propulsion" text,
  "launched_by" text,
  "country" text
);
SELECT "country" FROM "comparison" WHERE "propulsion"='solid rocket';