534. 游戏玩法分析 III

534. 游戏玩法分析 III

【order by 和group by都可以有多个参数】

# Write your MySQL query statement below
#sum函数，将a.games_played的值和b的相加，实现对b的叠加（a不变）
select b.player_id , b.event_date, sum(a.games_played)  games_played_so_far
from Activity a, Activity b
where b.event_date >= a.event_date and a.player_id = b.player_id
group by b.player_id, b.event_date
order by b.player_id, b.event_date