Table: colts_patriots_games
Columns: year
date
winner
result
loser
location

Question: Where was the game that the Indianapolis Colts lost 24-14?
SQL: SELECT "location" FROM colts_patriots_games WHERE "loser" = 'indianapolis colts' AND "result" = '24-14'

Question: On what date was the game that the Indianapolis Colts lost in 2004?
SQL: SELECT "date" FROM colts_patriots_games WHERE "loser" = 'indianapolis colts' AND "year" = 2004

Question: Which team won against the New England Patriots 40-21?
SQL: SELECT "winner" FROM colts_patriots_games WHERE "loser" = 'new england patriots' AND "result" = '40-21'

Question: What was the date of the game played at Gillette Stadium with a score of 40-21?
SQL: SELECT "date" FROM colts_patriots_games WHERE "location" = 'gillette stadium' AND "result" = '40-21'

Question: What year was the game that ended with a score of 24-14?
SQL: SELECT AVG("year") FROM colts_patriots_games WHERE "result" = '24-14'