Leetcode 3246 - Premier League Ranking ORDER RANK() WINDOW - Explained by Everyday Data Science

Опубликовано: 16 Март 2026
на канале: Everyday Data Science

561

Question: https://leetcode.com/problems/premier...

SQL Schema:
Create table if not exists TeamStats( team_id int, team_name varchar(100),matches_played int, wins int,draws int,losses int)
Truncate table TeamStats
insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('1', 'Manchester City', '10', '6', '2', '2')
insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('2', 'Liverpool', '10', '6', '2', '2')
insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('3', 'Chelsea', '10', '5', '3', '2')
insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('4', 'Arsenal', '10', '4', '4', '2')
insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('5', 'Tottenham', '10', '3', '5', '2')

Pandas Schema:
data = [[1, 'Manchester City', 10, 6, 2, 2], [2, 'Liverpool', 10, 6, 2, 2], [3, 'Chelsea', 10, 5, 3, 2], [4, 'Arsenal', 10, 4, 4, 2], [5, 'Tottenham', 10, 3, 5, 2]]
team_stats = pd.DataFrame(data, columns=["team_id", "team_name", "matches_played", "wins", "draws", "losses"]).astype({"team_id": "int", "team_name": "string", "matches_played": "int", "wins": "int", "draws": "int", "losses": "int"})

#leetcodesolutions #datascience #sql