Table: snf_results_6
Columns: date
visiting_team
final_score
host_team
stadium

Question: On what date did the New York Giants host a game?
SQL: SELECT "date" FROM snf_results_6 WHERE "host_team" = 'new york giants'

Question: Who was the host team for the game on December 27?
SQL: SELECT "host_team" FROM snf_results_6 WHERE "date" = 'december 27'

Question: What was the final score of the game at Texas Stadium?
SQL: SELECT "final_score" FROM snf_results_6 WHERE "stadium" = 'texas stadium'

Question: Who was the visiting team who played at the hubert h. humphrey metrodome stadium?
SQL: SELECT "visiting_team" FROM snf_results_6 WHERE "stadium" = 'hubert h. humphrey metrodome'

Question: When did the New England Patriots play as the visiting team?
SQL: SELECT "date" FROM snf_results_6 WHERE "visiting_team" = 'new england patriots'

Question: At which stadium did the Los Angeles Raiders play as the visiting team?
SQL: SELECT "stadium" FROM snf_results_6 WHERE "visiting_team" = 'los angeles raiders'