Skip to content

2339. All the Matches of the League 👍

1
2
3
4
5
6
SELECT
  Home.team_name AS home_team,
  Away.team_name AS away_team
FROM Teams AS Home
INNER JOIN Teams AS Away
WHERE Home.team_name != Away.team_name;