In Week 7, what is the highest attendance number?
CREATE TABLE table_name_77 (attendance INTEGER, week VARCHAR)
SELECT MAX(attendance) FROM table_name_77 WHERE week = 7
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_77 (attendance INTEGER, week VARCHAR) Question: In Week 7, what is the highest attendance number? [/INST] SELECT MAX(attendance) FROM table_name_77 WHERE week = 7 </s>