SQL 문제풀이

leetcode - 534. Game Play Analysis III

Jerrytwo 2022. 6. 26. 21:55

난이도 : Medium

 

 

 

SELECT player_id
     , event_date
     , SUM(games_played) OVER (PARTITION BY player_id ORDER BY event_date) games_played_so_far
FROM Activity

Accepted