Solution and walkthrough of leetcode database problem 1097: Game Play Analysis V. 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-v/
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
