How many Weeks are on september 8, 1980 and Attendances larger than 55,045? Question 4
CREATE TABLE table_name_22 (week VARCHAR, date VARCHAR, attendance VARCHAR)
SELECT COUNT(week) FROM table_name_22 WHERE date = "september 8, 1980" AND attendance > 55 OFFSET 045 ROWS
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_22 (week VARCHAR, date VARCHAR, attendance VARCHAR) Question: How many Weeks are on september 8, 1980 and Attendances larger than 55,045? Question 4 [/INST] SELECT COUNT(week) FROM table_name_22 WHERE date = "september 8, 1980" AND attendance > 55 OFFSET 045 ROWS </s>