SQL · Atlassian · Medium
Given the team and game tables, produce a result set showing each team’s three highest-scoring games from the 2024 season (season_year = 2024). The game table stores one row per contest from the point of view of the row’s team_id; the other side is identified by opponent_team_id. You must consider every contest from both teams’ perspectives. For example, if a recorded row has team A against team B, then B’s score from that same contest must also be treated as a separate…
Checking your access…