Table: week_1_amsterdam
Columns: week
date
kickoff
opponent
final_score
team_record
game_site
attendance

Question: On what dates was the final score of the game L 14–24?
SQL: SELECT "date" FROM week_1_amsterdam WHERE "final_score" = 'L 14–24'

Question: How many game sites are there where the team record is 1–7?
SQL: SELECT COUNT("game_site") FROM week_1_amsterdam WHERE "team_record" = '1–7'

Question: On week 7, what were the opponents?
SQL: SELECT "opponent" FROM week_1_amsterdam WHERE "week" = 7

Question: On what game sites are there where the team record is 0–5?
SQL: SELECT "game_site" FROM week_1_amsterdam WHERE "team_record" = '0–5'

Question: What game sites are where the team record is 1–6?
SQL: SELECT "game_site" FROM week_1_amsterdam WHERE "team_record" = '1–6'

Question: In game site AOL Arena, who are all the opponents?
SQL: SELECT "opponent" FROM week_1_amsterdam WHERE "game_site" = 'AOL Arena'