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

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