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

select u.name u_n,p.date date,
        sum(p.number) over (partition by u.name rows between unbounded preceding
                           and current row) num
from login l
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
order by p.date,u.name
;


select u.name u_n,p.date date,
        sum(p.number) over (partition by u.name  order by p.date) num
from passing_number p
JOIN user u 
on p.user_id=u.id
order by p.date,u.name
;