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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: 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? ### Input: CREATE TABLE table_name_97 (
    week INTEGER,
    opponent VARCHAR,
    attendance VARCHAR
) ### Response: SELECT SUM(week) FROM table_name_97 WHERE opponent = "houston oilers" AND attendance > 54 OFFSET 582