SQL每日一题(20201229)查询每个玩家每天累计玩的游戏数量有多少？

SQL每日一题(20220622)
SQL每日一题(20220725)

select plan_id, device_id,games_player,
       sum(games_player) over (partition by plan_id order by device_id ,games_player ) games_player
from Activity

SELECT b.plan_id, a.event_date,SUM(b.games_player)
FROM activity a
         JOIN activity b ON a.plan_id = b.plan_id AND a.event_date >= b.event_date
GROUP BY b.plan_id, a.event_date
ORDER BY b.plan_id, a.event_date;

SELECT a.plan_id,
       a.event_date,
       (SELECT SUM(b.games_player) FROM activity b WHERE b.plan_id = a.plan_id AND b.event_date <= a.event_date) 累计
FROM activity a
ORDER BY a.plan_id, a.event_date;