Table: cardinals_1988_weeks
Columns: week
date
opponent
result
attendance

Question: Which Attendance has a Week of 8?
SQL: SELECT AVG("attendance") FROM cardinals_1988_weeks WHERE "week" = 8

Question: Which Opponent that has a Week smaller than 7 on september 12, 1988?
SQL: SELECT "opponent" FROM cardinals_1988_weeks WHERE "week" < 7 AND "date" = 'september 12, 1988'

Question: When has a Result of w 41-27?
SQL: SELECT "date" FROM cardinals_1988_weeks WHERE "result" = 'w 41-27'