Table: dsl_connection_details
Columns: dsl_type
provider
resale
down_up_to_kbit_s
up_up_to_kbit_s

Question: How many providers are there where the resale category is yes and bandwith is up is 1024?
SQL: SELECT COUNT("provider") FROM dsl_connection_details WHERE "resale" = 'yes' AND "up_up_to_kbit_s" = 1024

Question: What is download bandwith where the provider is deutsche telekom ag?
SQL: SELECT MAX("down_up_to_kbit_s") FROM dsl_connection_details WHERE "provider" = 'Deutsche Telekom AG'

Question: Who are all of the telecom providers for which the upload rate is 1024 kbits and the resale category is yes?
SQL: SELECT "provider" FROM dsl_connection_details WHERE "up_up_to_kbit_s" = 1024 AND "resale" = 'yes'

Question: What are all the dsl type offered by the M-Net telecom company?
SQL: SELECT "dsl_type" FROM dsl_connection_details WHERE "provider" = 'M-net'

Question: What is the resale category for the provider NetCologne?
SQL: SELECT "resale" FROM dsl_connection_details WHERE "provider" = 'Netcologne'