Table: cardinals_games_2001
Columns: week
date
opponent
result
tv_time
attendance

Question: Who is the opponent in week 15?
SQL: SELECT "opponent" FROM cardinals_games_2001 WHERE "week" = 15

Question: What is the highest attendance a result of W 30-7?
SQL: SELECT MAX("attendance") FROM cardinals_games_2001 WHERE "result" = 'w 30-7'

Question: What is the average attendance at week earlier than 6 on October 14, 2001?
SQL: SELECT AVG("attendance") FROM cardinals_games_2001 WHERE "week" < 6 AND "date" = 'october 14, 2001'