In how many weeks was the game played on November 3 played?
CREATE TABLE table_17869717_1 (week VARCHAR, date VARCHAR)
SELECT COUNT(week) FROM table_17869717_1 WHERE date = "November 3"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_17869717_1 (week VARCHAR, date VARCHAR) Question: In how many weeks was the game played on November 3 played? [/INST] SELECT COUNT(week) FROM table_17869717_1 WHERE date = "November 3" </s>