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