Table: intl_football_clubs
Columns: year
team
progress
score
opponents

Question: What were the Opponents of the team, that made it to the third round, before 2008?
SQL: SELECT "opponents" FROM intl_football_clubs WHERE "year" < 2008 AND "progress" = 'third round'

Question: What was the score in 1997 for the team that has a Progress of no entrants?
SQL: SELECT "score" FROM intl_football_clubs WHERE "progress" = 'no entrants' AND "year" = 1997