Table: dsl_stats
Columns: dsl_type
provider
resale
down_up_to_kbit_s
up_up_to_kbit_s

Question: who is the provider when up (up to kbit/s) is 1180?
SQL: SELECT "provider" FROM dsl_stats WHERE "up_up_to_kbit_s" = 1180

Question: what is the highest down (up to kbits/s) when resale is yes, up ( up to kbit/s) is 1180 and provider is 1&1?
SQL: SELECT MAX("down_up_to_kbit_s") FROM dsl_stats WHERE "resale" = 'yes' AND "up_up_to_kbit_s" = 1180 AND "provider" = '1&1'

Question: what is the resale when the down (up to kbit/s) is 24000?
SQL: SELECT "resale" FROM dsl_stats WHERE "down_up_to_kbit_s" = 24000

Question: What is the average down (up to kbit/s) when the provider is willy.tel and the up (kbit/s) is more than 1984?
SQL: SELECT AVG("down_up_to_kbit_s") FROM dsl_stats WHERE "provider" = 'willy.tel' AND "up_up_to_kbit_s" > 1984