I want the attendance which has a result of l 49–21
CREATE TABLE table_name_12 (attendance VARCHAR, result VARCHAR)
SELECT attendance FROM table_name_12 WHERE result = "l 49–21"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_12 (attendance VARCHAR, result VARCHAR) Question: I want the attendance which has a result of l 49–21 [/INST] SELECT attendance FROM table_name_12 WHERE result = "l 49–21" </s>