How many networks are listed when the year is 2008?
CREATE TABLE table_2941848_10 (network VARCHAR, year VARCHAR)
SELECT COUNT(network) FROM table_2941848_10 WHERE year = 2008
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_2941848_10 (network VARCHAR, year VARCHAR) Question: How many networks are listed when the year is 2008? [/INST] SELECT COUNT(network) FROM table_2941848_10 WHERE year = 2008 </s>