题解 | #牛客每个人最近的登录日期(六)#

select user.name, passing_number.date, sum(passing_number.number)over(partition by passing_number.user_id order by passing_number.date)
from passing_number left join user on passing_number.user_id=user.id
order by passing_number.date, user.name