LeetCode 511: Game Play Analysis I [SQL]

Solution and walkthrough of leetcode database problem 511: Game Play Analysis I. I'm using MySQL but this solution should work in any SQL dialect such as PostgreSQL SQL Server, etc.

Link to the problem: https://leetcode.com/problems/game-play-analysis-i

Game Play Analysis I: https://youtu.be/_0JIcJ83BLE
Game Play Analysis II: https://youtu.be/vaso8C8huUc
Game Play Analysis III: https://youtu.be/Xdfqjknr1Gw
Game Play Analysis IV: https://youtu.be/qj92XriUohY

Playlists:

LeetCode database SQL problems: https://youtube.com/playlist?list=PLdrw9_aIADIPAMJW8I_S-S747oyiRtzpS

Easy SQL problems: https://youtube.com/playlist?list=PLdrw9_aIADINpdkxu_RHaY16QmG8-mRSm
Medium SQL problems: https://youtube.com/playlist?list=PLdrw9_aIADIMSQe_-m6xknIdPPNiYngKh
Hard SQL problems: https://youtube.com/playlist?list=PLdrw9_aIADIP0sYoOt2mql4Hb06Y1D0z2

Видео LeetCode 511: Game Play Analysis I [SQL] канала Frederik Müller