Which Attendance has a Result of w 24-14, and a Week smaller than 7?
CREATE TABLE table_name_2 (attendance INTEGER, result VARCHAR, week VARCHAR)
SELECT SUM(attendance) FROM table_name_2 WHERE result = "w 24-14" AND week < 7
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_2 (attendance INTEGER, result VARCHAR, week VARCHAR) Question: Which Attendance has a Result of w 24-14, and a Week smaller than 7? [/INST] SELECT SUM(attendance) FROM table_name_2 WHERE result = "w 24-14" AND week < 7 </s>