Table: tnf_football_results
Columns: week
date
visiting_team
final_score
host_team
stadium

Question: What week was the final score 6–26?
SQL: SELECT "week" FROM tnf_football_results WHERE "final_score" = '6–26'

Question: Who was the host team when the Miami Dolphins were the visiting team?
SQL: SELECT "host_team" FROM tnf_football_results WHERE "visiting_team" = 'miami dolphins'

Question: What was the stadium that held that game after week 15?
SQL: SELECT "stadium" FROM tnf_football_results WHERE "week" > 15