Table: rams_2004_season
Columns: week
date
opponent
result
record
attendance

Question: Which opponent had an attendance of 40,070?
SQL: SELECT "opponent" FROM rams_2004_season WHERE "attendance" = '40,070'

Question: What's the result for the game held on December 27, 2004 with a week greater than 2?
SQL: SELECT "result" FROM rams_2004_season WHERE "week" > 2 AND "date" = 'december 27, 2004'

Question: Who was the opponent for week 6?
SQL: SELECT "opponent" FROM rams_2004_season WHERE "week" = 6

Question: Which opponent had the result of W 24-14?
SQL: SELECT "opponent" FROM rams_2004_season WHERE "result" = 'w 24-14'

Question: What's the attendance for the game held on January 2, 2005?
SQL: SELECT "attendance" FROM rams_2004_season WHERE "date" = 'january 2, 2005'