题解 | #牛客每个人最近的登录日期(六)#

select
    name,
    date,
    sum(number) over(partition by user_id order by date) as 'cum_cnt'
from 
    passing_number p, user u
where 
    p.user_id = u.id
order by 
    date, name