题解 | #牛客每个人最近的登录日期(六)#
牛客每个人最近的登录日期(六)
https://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
-- 强化使用窗口函数
select b.name,a.date,
sum(a.number)over( partition by b.name order by date) as ps_num
from passing_number a
join user b on a.user_id =b.id
order by a.date,b.name
