LeetCode 534: Game Play Analysis III [SQL]

[@UmaAndLak]

Loved to see how the window function simplified the query here! Thank you for helping us understand this better.

[@frederikmuller]

Thanks for leaving so many comments!

[@whiterabbit9428]

Thanks for your excellent explanation!

[@nukagvilia4141]

Thanks for a great video! Could you explain which solution would be better in terms of time complexity? Which is faster, window functions or self joins?

[@HenggaoCai]

Well said!

[@rishianand4892]

select player_id,event_date, (select sum(games_played) from activity a2 where a2.player_id=a1.player_id and a2.event_date

[@parveshkiran7217]

while giving explanation just try to give in a manner that its easy to understand..ur explanation is good but ur way of explanation is like speaking to urself

[@frederikmuller]

thanks for the constructive feedback, I'll try incorporating that into my future videos!

[@rahulpoptani90]

@@frederikmuller You are doing great! No need to change anything!

[@johnhhu2137]

So the code actually works like python code, running row by row

[@rishianand4892]

Will below query work: select player_id,MAX(event_date) AS event_date,sum(games_played) as games_played_so_far from activity a1 where (player_id,event_date) in (select player_id,event_date from activity a2 where a2.player_id=a1.player_id and a2.event_date

[@ruthraramanan3407]

*alarm went off*🤣🤣🤣

[@ujjwalshrivastava3594]

if u can put table schema it will really be good

[@johnhhu2137]

Here is my code on Datagrip, just not understand very well on: SUM(b.games_played) a.event_data=b.event_date GROUP BY a.player_id,a.device_id,a.event_date;

[@ruthraramanan3407]

it's just the main table(in ur case b) date should be less than the iterating table(a). that's why a.event_date>=b.event_date. Else the way Fred did is vice versa. Hope u understand.