Leetcode MEDIUM 3252 - Premier League Table Ranking 2 WINDOW - Explained by Everyday Data Science

Question: leetcode.com/p...
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', 'Chelsea', '22', '13', '2', '7')
insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('2', 'Nottingham Forest', '27', '6', '6', '15')
insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('3', 'Liverpool', '17', '1', '8', '8')
insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('4', 'Aston Villa', '20', '1', '6', '13')
insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('5', 'Fulham', '31', '18', '1', '12')
insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('6', 'Burnley', '26', '6', '9', '11')
insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('7', 'Newcastle United', '33', '11', '10', '12')
insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('8', 'Sheffield United', '20', '18', '2', '0')
insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('9', 'Luton Town', '5', '4', '0', '1')
insert into TeamStats (team_id, team_name, matches_played, wins, draws, losses) values ('10', 'Everton', '14', '2', '6', '6')
Pandas Schema:
data = [[1, 'Chelsea', 22, 13, 2, 7], [2, 'Nottingham Forest', 27, 6, 6, 15], [3, 'Liverpool', 17, 1, 8, 8], [4, 'Aston Villa', 20, 1, 6, 13], [5, 'Fulham', 31, 18, 1, 12], [6, 'Burnley', 26, 6, 9, 11], [7, 'Newcastle United', 33, 11, 10, 12], [8, 'Sheffield United', 20, 18, 2, 0], [9, 'Luton Town', 5, 4, 0, 1], [10, 'Everton', 14, 2, 6, 6]]
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

[@anupam5028]

Sir create your SQL set questions from leetcode ??

[@gajendragada_dynamites]

Welcome back sir