What average week has october 8, 1950 as the date?
CREATE TABLE table_name_8 (week INTEGER, date VARCHAR)
SELECT AVG(week) FROM table_name_8 WHERE date = "october 8, 1950"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_8 (week INTEGER, date VARCHAR) Question: What average week has october 8, 1950 as the date? [/INST] SELECT AVG(week) FROM table_name_8 WHERE date = "october 8, 1950" </s>