# $534. 游戏玩法分析 III
# https://leetcode-cn.com/problems/game-play-analysis-iii/

# SQL架构
Create table If Not Exists Activity (player_id int, device_id int, event_date date, games_played int);
Truncate table Activity;
insert into Activity (player_id, device_id, event_date, games_played) values ('1', '2', '2016-03-01', '5');
insert into Activity (player_id, device_id, event_date, games_played) values ('1', '2', '2016-05-02', '6');
insert into Activity (player_id, device_id, event_date, games_played) values ('1', '3', '2017-06-25', '1');
insert into Activity (player_id, device_id, event_date, games_played) values ('3', '1', '2016-03-02', '0');
insert into Activity (player_id, device_id, event_date, games_played) values ('3', '4', '2018-07-03', '5');

# Write your MySQL query statement below
select
    a1.player_id,
    a2.event_date,
    sum(a1.games_played) as games_played_so_far
from
    Activity a1
    inner join Activity a2 on a1.player_id = a2.player_id
    and a1.event_date <= a2.event_date
group by
    a2.player_id,
    a2.event_date;

# clean-up
drop table Activity;