Table: snf_results_9
Columns: date
visiting_team
final_score
host_team
stadium

Question: What game had the date was it with the final score of 7-23
SQL: SELECT "date" FROM snf_results_9 WHERE "final_score" = '7-23'

Question: What was the final score of the game at the astrodome?
SQL: SELECT "final_score" FROM snf_results_9 WHERE "stadium" = 'astrodome'

Question: What was the final score for the date of December 30?
SQL: SELECT "final_score" FROM snf_results_9 WHERE "date" = 'december 30'

Question: What was the name of the Visiting team at Jack Murphy Stadium?
SQL: SELECT "visiting_team" FROM snf_results_9 WHERE "stadium" = 'jack murphy stadium'

Question: What was the name of the host team at Texas stadium?
SQL: SELECT "host_team" FROM snf_results_9 WHERE "stadium" = 'texas stadium'

Question: What was the name of the host team dated December 16?
SQL: SELECT "host_team" FROM snf_results_9 WHERE "date" = 'december 16'