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

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