Table: oil_1990_season
Columns: week
date
opponent
result
attendance

Question: What is the attendance when the opponent is the San Francisco 49ers?
SQL: SELECT "attendance" FROM oil_1990_season WHERE "opponent" = 'san francisco 49ers'

Question: What is the result when the week is greater than 6 and the Buffalo Bills are the opponent?
SQL: SELECT "result" FROM oil_1990_season WHERE "week" > 6 AND "opponent" = 'buffalo bills'

Question: What is the result when the attendance is 54,814?
SQL: SELECT "result" FROM oil_1990_season WHERE "attendance" = '54,814'

Question: What is the total number of weeks when the New York Jets are the opponent?
SQL: SELECT COUNT("week") FROM oil_1990_season WHERE "opponent" = 'new york jets'

Question: What is the result of the game when the attendance is 56,906?
SQL: SELECT "result" FROM oil_1990_season WHERE "attendance" = '56,906'