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

Question: How many site entries are there at 3:30pm and the visiting team is coastal carolina?
SQL: SELECT COUNT("site") FROM game_results_8 WHERE "time" = '3:30pm' AND "visiting_team" = 'Coastal Carolina'

Question: What is the result when the visiting team is syracuse?
SQL: SELECT "result" FROM game_results_8 WHERE "visiting_team" = 'Syracuse'