Leetcode Problem 2339. All the Matches of the League

2339. All the Matches of the League

Leetcode Solutions

Perform a cross join on the Teams table with itself, aliasing one instance as T1 (representing the home team) and the other as T2 (representing the away team).
Use a WHERE clause to filter out the rows where T1.team_name is equal to T2.team_name, as a team cannot play against itself.
Select T1.team_name as home_team and T2.team_name as away_team to represent the match pairing.
The result will include all possible match pairings with each team playing as both home and away against every other team.


erDiagram
    Teams {
        varchar team_name PK
    }

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen