题解 | #牛客每个人最近的登录日期(六)#
牛客每个人最近的登录日期(六)
https://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
with t1 as (
select a.name as u_n, b.date, b.number as ps_num
from passing_number as b
left join user as a
on a.id = b.user_id
)
select u_n, date, sum(ps_num) over(partition by u_n order by date) as ps_num
from t1
order by date, u_n;
投递美团等公司8个岗位
