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

Question: Opponent of new england patriots had what attendance?
SQL: SELECT "attendance" FROM colts_97_indy WHERE "opponent" = 'new england patriots'

Question: Attendance of 55,340 had what opponent?
SQL: SELECT "opponent" FROM colts_97_indy WHERE "attendance" = '55,340'

Question: Week smaller than 4, and a Game Site of rca dome, and a Opponent of new england patriots involves what date?
SQL: SELECT "date" FROM colts_97_indy WHERE "week" < 4 AND "game_site" = 'rca dome' AND "opponent" = 'new england patriots'

Question: Record of 0–8 had what result?
SQL: SELECT "result" FROM colts_97_indy WHERE "record" = '0–8'

Question: Record of 0–8 had what lowest week?
SQL: SELECT MIN("week") FROM colts_97_indy WHERE "record" = '0–8'