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