Who was the opponent for week 6?
CREATE TABLE table_name_40 (opponent VARCHAR, week VARCHAR)
SELECT opponent FROM table_name_40 WHERE week = 6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (opponent VARCHAR, week VARCHAR) Question: Who was the opponent for week 6? [/INST] SELECT opponent FROM table_name_40 WHERE week = 6 </s>