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)
SELECT COUNT(provider) FROM table_1773908_3 WHERE resale = "yes" AND up__up_to_kbit_s_ = 1024
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1773908_3 (provider VARCHAR, resale VARCHAR, up__up_to_kbit_s_ VARCHAR) Question: How many providers are there where the resale category is yes and bandwith is up is 1024? [/INST] SELECT COUNT(provider) FROM table_1773908_3 WHERE resale = "yes" AND up__up_to_kbit_s_ = 1024 </s>