Table: texans_02_houston_season
Columns: week
date
opponent
result
game_site
record
attendance

Question: What's the highest attendance for a game the Texan's played at Arrowhead Stadium?
SQL: SELECT MAX("attendance") FROM texans_02_houston_season WHERE "game_site" = 'arrowhead stadium'

Question: Who did the Texan's play on Week 4?
SQL: SELECT "opponent" FROM texans_02_houston_season WHERE "week" = '4'

Question: What's the date for HOF week?
SQL: SELECT "date" FROM texans_02_houston_season WHERE "week" = 'hof'