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

How many analogue satellite channels does Sky [Analogue] have?
SELECT "No. of channels" FROM table_58974 WHERE "Transmission" = 'analogue satellite' AND "Provider" = 'sky [analogue]'
SELECT "No. of channels" FROM "table_58974" WHERE "Provider" = 'sky [analogue]' AND "Transmission" = 'analogue satellite'