CREATE TABLE table_58973 ("Provider" CLOB, "Years" CLOB, "Free or pay" CLOB, "No. of channels" CLOB, "Colour" CLOB, "Digital" CLOB, "Transmission" CLOB)

Which provider is pay with analogue cable?
SELECT "Provider" FROM table_58973 WHERE "Free or pay" = 'pay' AND "Transmission" = 'analogue cable'
SELECT "Provider" FROM "table_58973" WHERE "Free or pay" = 'pay' AND "Transmission" = 'analogue cable'