Table: football_games_3
Columns: week
date
kickoff
opponent
final_score
team_record
game_site
attendance

Question: How many weeks are teams playing agains the Barcelona dragons?
SQL: SELECT COUNT("week") FROM football_games_3 WHERE "opponent" = 'Barcelona Dragons'

Question: What was the score for the game that kicked off at 6:00 p.m.?
SQL: SELECT "final_score" FROM football_games_3 WHERE "kickoff" = '6:00 p.m.'

Question: Who are the opponents for games on Sunday, June 9?
SQL: SELECT "opponent" FROM football_games_3 WHERE "date" = 'Sunday, June 9'