534. 游戏玩法分析 III
select a.player_id,b.event_date,sum(a.games_played) as games_played_so_far
from Activity a
inner join Activity b on a.player_id=b.player_id and a.event_date<=b.event_date
group by b.player_id,b.event_date;
Table: Activity
+--------------+---------+ | Column Name | Type | +--------------+---------+ | player_id | int | | device_id | int | | event_date | date | | games_played | int | +--------------+---------+ (player_id,event_date)是此表的主键。 这张表显示了某些游
共有 0 条评论