Table: snf_results_4
Columns: date
visiting_team
final_score
host_team
stadium

Question: What visiting team played on October 18?
SQL: SELECT "visiting_team" FROM snf_results_4 WHERE "date" = 'october 18'

Question: What visiting team played at 3com park on October 7?
SQL: SELECT "visiting_team" FROM snf_results_4 WHERE "stadium" = '3com park' AND "date" = 'october 7'

Question: Which host team won on a final scoreline of 13-10?
SQL: SELECT "host_team" FROM snf_results_4 WHERE "final_score" = '13-10'

Question: In what stadium did a game result in a final scoreline reading 27-34?
SQL: SELECT "stadium" FROM snf_results_4 WHERE "final_score" = '27-34'

Question: In the game in which the Jacksonville Jaguars were hosts, what was the name of the visiting team?
SQL: SELECT "visiting_team" FROM snf_results_4 WHERE "host_team" = 'jacksonville jaguars'

Question: Which visiting team wound up with a final score of 18-40?
SQL: SELECT "visiting_team" FROM snf_results_4 WHERE "final_score" = '18-40'