Table: chargers_1979
Columns: week
date
opponent
result
attendance

Question: On September 30, 1979, in a week before week 8, what was the result?
SQL: SELECT "result" FROM chargers_1979 WHERE "week" < 8 AND "date" = 'september 30, 1979'

Question: What was the average attendance in week 2?
SQL: SELECT AVG("attendance") FROM chargers_1979 WHERE "week" = 2