Table: uk_tv_providers
Columns: provider
years
free_or_pay
transmission
on_demand

Question: Name the  Provider that has a pay in 2006–, and a Transmission of iptv and digital terrestrial?
SQL: SELECT "provider" FROM uk_tv_providers WHERE "free_or_pay" = 'pay' AND "years" = '2006–' AND "transmission" = 'iptv and digital terrestrial'

Question: Name the Years which have Transmission of digital satellite, an On demand of no, and a Free or pay of free + ppv?
SQL: SELECT "years" FROM uk_tv_providers WHERE "transmission" = 'digital satellite' AND "on_demand" = 'no' AND "free_or_pay" = 'free + ppv'

Question: What kind of Free or pay has Years of 2006– and a Provider of bt tv (formerly bt vision)?
SQL: SELECT "free_or_pay" FROM uk_tv_providers WHERE "years" = '2006–' AND "provider" = 'bt tv (formerly bt vision)'

Question: Name the Years that have a  free + pay?
SQL: SELECT "years" FROM uk_tv_providers WHERE "free_or_pay" = 'free + pay'

Question: Which On demandhas a Free or pay of free and a Provider of freesat?
SQL: SELECT "on_demand" FROM uk_tv_providers WHERE "free_or_pay" = 'free' AND "provider" = 'freesat'

Question: Which On demand has a pay and a Provider of virgin media (formerly ntl:telewest)?
SQL: SELECT "on_demand" FROM uk_tv_providers WHERE "free_or_pay" = 'pay' AND "provider" = 'virgin media (formerly ntl:telewest)'