Tell me the week for result of l 31-27, and an Attendance smaller than 85,865
CREATE TABLE table_name_99 (week INTEGER, result VARCHAR, attendance VARCHAR)
SELECT AVG(week) FROM table_name_99 WHERE result = "l 31-27" AND attendance < 85 OFFSET 865 ROWS
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_99 (week INTEGER, result VARCHAR, attendance VARCHAR) Question: Tell me the week for result of l 31-27, and an Attendance smaller than 85,865 [/INST] SELECT AVG(week) FROM table_name_99 WHERE result = "l 31-27" AND attendance < 85 OFFSET 865 ROWS </s>