Table: snf_results
Columns: date
visiting_team
final_score
host_team
stadium

Question: Who was the visiting team on November 10?
SQL: SELECT "visiting_team" FROM snf_results WHERE "date" = 'november 10'

Question: Who was the host team for the game with the final score of 26-24?
SQL: SELECT "host_team" FROM snf_results WHERE "final_score" = '26-24'

Question: Who was the host team on November 17?
SQL: SELECT "host_team" FROM snf_results WHERE "date" = 'november 17'

Question: At what stadium was the game with the final score of 9-23 played?
SQL: SELECT "stadium" FROM snf_results WHERE "final_score" = '9-23'

Question: At what stadium was the game with the final score of 26-24 played?
SQL: SELECT "stadium" FROM snf_results WHERE "final_score" = '26-24'

Question: Which host team played against the New England Patriots?
SQL: SELECT "host_team" FROM snf_results WHERE "visiting_team" = 'new england patriots'