World Cup Database

Hey guys!
I’m stuck with the World Cup Database level. I have finished the queries, but as you can see on the screenshots attached the expected output is different from what the database contains: Netherlands and Switzerland (136 and 142) are repeated and United States and Costa Rica are missing instead.
Could you please fix this or is there another way I can finish the current level?

PS: As a new user I can only upload one screenshot but I hope I explained my self.

My script is: SELECT name FROM games INNER JOIN teams ON games.winner_id=teams.team_id OR games.opponent_id=teams.team_id WHERE year=2014 AND round=‘Eighth-Final’ ORDER BY name

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.