Table: conference_football_games_5
Columns: date
time
visiting_team
home_team
site
broadcast
result
attendance

Question: Where's the louisiana-lafayette as a visiting team?
SQL: SELECT "site" FROM conference_football_games_5 WHERE "visiting_team" = 'Louisiana-Lafayette'

Question: What were the results of the  tennessee tech as a visiting team?
SQL: SELECT "result" FROM conference_football_games_5 WHERE "visiting_team" = 'Tennessee Tech'

Question: What is the home team where the San Jose state is the visiting team?
SQL: SELECT "home_team" FROM conference_football_games_5 WHERE "visiting_team" = 'San Jose State'

Question: What were the results in the bryant-denny stadium • tuscaloosa, al?
SQL: SELECT "result" FROM conference_football_games_5 WHERE "site" = 'Bryant-Denny Stadium • Tuscaloosa, AL'

Question: What home team is at  7:30pm in ESPN?
SQL: SELECT "home_team" FROM conference_football_games_5 WHERE "time" = '7:30pm' AND "broadcast" = 'ESPN'