题解 | #牛客每个人最近的登录日期(六)#
牛客每个人最近的登录日期(六)
https://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
select
u.name as u_n
,p.date
,sum(p.number) over (partition by u.name order by date) as ps_num
from passing_number p
left join user u on p.user_id = u.id
order by 2 asc,1 asc