Skip to content

Latest commit

 

History

History
19 lines (11 loc) · 470 Bytes

File metadata and controls

19 lines (11 loc) · 470 Bytes

中文文档

Description

None

Solutions

SQL

select a.player_id, a.event_date, sum(b.games_played) as games_played_so_far from Activity a, Activity b where a.player_id = b.player_id and a.event_date >= b.event_date group by a.player_id, a.event_date