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

select
    u.name,
    p_n.date,
    sum(number) over (partition by p_n.user_id order by p_n.date) as ps_num
from    
    passing_number as p_n
left join   
    user as u
on 
    p_n.user_id = u.id
order by 
    p_n.date,
    u.name