Table: phone_tariffs
Columns: scheme
tariff_code
bts_retail_price_regulated
approx_premium
prefixes

Question: What is the regulated retail price for the tariff code ff0 prs?
SQL: SELECT "bts_retail_price_regulated" FROM phone_tariffs WHERE "tariff_code" = 'ff0 PRS'

Question: What is the premium associated with tariff code g9?
SQL: SELECT "approx_premium" FROM phone_tariffs WHERE "tariff_code" = 'g9'

Question: How many tariff codes have a bts retail price of 2p/min or inclusive?
SQL: SELECT COUNT("tariff_code") FROM phone_tariffs WHERE "bts_retail_price_regulated" = '2p/min or inclusive'

Question: How many tariff codes have a bts retail price of 2.553p/min?
SQL: SELECT COUNT("tariff_code") FROM phone_tariffs WHERE "bts_retail_price_regulated" = '2.553p/min'

Question: What prefixes are priced at pence per minute, fixed at all times with a premium of 3p/min?
SQL: SELECT "prefixes" FROM phone_tariffs WHERE "scheme" = 'Pence per minute, fixed at all times' AND "approx_premium" = '3p/min'

Question: What is the bts retail price (regulated) for tariff code g10?
SQL: SELECT "bts_retail_price_regulated" FROM phone_tariffs WHERE "tariff_code" = 'g10'