Table: tnf_football_results_4
Columns: week
date
visiting_team
final_score
host_team
stadium

Question: What is the home stadium of the Tennessee Titans?
SQL: SELECT "stadium" FROM tnf_football_results_4 WHERE "host_team" = 'tennessee titans'

Question: When were the Houston Texans the visiting team later in the season?
SQL: SELECT MAX("week") FROM tnf_football_results_4 WHERE "visiting_team" = 'houston texans'

Question: The final score was 24-34 on what date?
SQL: SELECT "date" FROM tnf_football_results_4 WHERE "final_score" = '24-34'