What was the attendance for the week before 10 with a result of L 12-15
CREATE TABLE table_name_86 (attendance VARCHAR, week VARCHAR, result VARCHAR)
SELECT attendance FROM table_name_86 WHERE week < 10 AND result = "l 12-15"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_86 (attendance VARCHAR, week VARCHAR, result VARCHAR) Question: What was the attendance for the week before 10 with a result of L 12-15 [/INST] SELECT attendance FROM table_name_86 WHERE week < 10 AND result = "l 12-15" </s>