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

select   name, l.date, sum(`number`)over(partition by l.user_id order by l.date) ps_num
from login l
join passing_number p
on l.user_id = p.user_id and l.date = p.date
join `user` u
on u.id = l.user_id
order by l.date, name