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