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