How many providers are there where the resale category is yes and bandwith is up is 1024?
create table table_1773908_3 (provider varchar, resale varchar, up__up_to_kbit_s_ varchar, PRIMARY KEY (provider))
select count(provider) from table_1773908_3 where resale = "yes" and up__up_to_kbit_s_ = 1024