Table: uk_tv_history
Columns: provider
years
free_or_pay
no_of_channels
colour
digital
transmission

Question: What is the digital of Virgin [analogue]?
SQL: SELECT "digital" FROM uk_tv_history WHERE "provider" = 'virgin [analogue]'

Question: Which provider is pay with analogue cable?
SQL: SELECT "provider" FROM uk_tv_history WHERE "free_or_pay" = 'pay' AND "transmission" = 'analogue cable'

Question: How many analogue satellite channels does Sky [Analogue] have?
SQL: SELECT "no_of_channels" FROM uk_tv_history WHERE "transmission" = 'analogue satellite' AND "provider" = 'sky [analogue]'

Question: What years are listed for analogue cable with 35 channels?
SQL: SELECT "years" FROM uk_tv_history WHERE "transmission" = 'analogue cable' AND "no_of_channels" = '35'