What was the result of the game prior to week 9 with an attendance of 49,970?
CREATE TABLE table_name_23 (result VARCHAR, week VARCHAR, attendance VARCHAR)
SELECT result FROM table_name_23 WHERE week < 9 AND attendance = "49,970"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_23 (result VARCHAR, week VARCHAR, attendance VARCHAR) Question: What was the result of the game prior to week 9 with an attendance of 49,970? [/INST] SELECT result FROM table_name_23 WHERE week < 9 AND attendance = "49,970" </s>