What is the sum of the weeks during which the Redskins played against the Houston Oilers and had more than 54,582 fans in attendance?
CREATE TABLE table_name_97 (week INTEGER, opponent VARCHAR, attendance VARCHAR)
SELECT SUM(week) FROM table_name_97 WHERE opponent = "houston oilers" AND attendance > 54 OFFSET 582 ROWS
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_97 (week INTEGER, opponent VARCHAR, attendance VARCHAR) Question: What is the sum of the weeks during which the Redskins played against the Houston Oilers and had more than 54,582 fans in attendance? [/INST] SELECT SUM(week) FROM table_name_97 WHERE opponent = "houston oilers" AND attendance > 54 OFFSET 582 ROWS </s>