Name the most attendance for november 17, 1946 and week more than 8
CREATE TABLE table_name_21 (attendance INTEGER, date VARCHAR, week VARCHAR)
SELECT MAX(attendance) FROM table_name_21 WHERE date = "november 17, 1946" AND week > 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_21 (attendance INTEGER, date VARCHAR, week VARCHAR) Question: Name the most attendance for november 17, 1946 and week more than 8 [/INST] SELECT MAX(attendance) FROM table_name_21 WHERE date = "november 17, 1946" AND week > 8 </s>