What is the unit for a submarine type ship from Norway?
CREATE TABLE "vessels" (
  "vessel" text,
  "origin" text,
  "type" text,
  "in_service" real,
  "unit" text
);
SELECT "unit" FROM "vessels" WHERE "type"='submarine' AND "origin"='norway';