CREATE TABLE table_72928 ("DSL Type" CLOB, "Provider" CLOB, "Resale" CLOB, "Down  ( up to kbit/s ) " FLOAT, "Up  ( up to kbit/s ) " FLOAT)

How many providers are there where the resale category is yes and bandwith is up is 1024?
SELECT COUNT("Provider") FROM table_72928 WHERE "Resale" = 'yes' AND "Up (up to kbit/s)" = '1024'
SELECT COUNT("Provider") FROM "table_72928" WHERE "Resale" = 'yes' AND "Up (up to kbit/s)" = '1024'