Record of 8–1, and a Week larger than 9 had what highest attendance?
CREATE TABLE table_name_18 (attendance INTEGER, record VARCHAR, week VARCHAR)
SELECT MAX(attendance) FROM table_name_18 WHERE record = "8–1" AND week > 9
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_18 (attendance INTEGER, record VARCHAR, week VARCHAR) Question: Record of 8–1, and a Week larger than 9 had what highest attendance? [/INST] SELECT MAX(attendance) FROM table_name_18 WHERE record = "8–1" AND week > 9 </s>