Which provider is pay with analogue cable?
CREATE TABLE "closed_and_aborted_television_providers" (
  "provider" text,
  "years" text,
  "free_or_pay" text,
  "no_of_channels" text,
  "colour" text,
  "digital" text,
  "transmission" text
);
SELECT "provider" FROM "closed_and_aborted_television_providers" WHERE "free_or_pay"='pay' AND "transmission"='analogue cable';