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)是此表的主键。 这张表显示了某些游

534. 游戏玩法分析 III最先出现在Python成神之路

版权声明:
作者:Alex
链接:https://www.techfm.club/p/6945.html
来源:TechFM
文章版权归作者所有,未经允许请勿转载。

THE END
分享
二维码
< <上一篇
下一篇>>