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

select
    u_n,
    date,
    sum(ps_num) over (partition by u_n order by date) as ps_num
from
    (
        select
            u.name as u_n,
            l.date as date,
            number as ps_num
        from login l
        left join passing_number p on (l.user_id = p.user_id and l.date = p.date)
        join user u on l.user_id = u.id
    ) t1
where t1.ps_num is not null
order by date, u_n