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

方法：窗口函数

select u.name,l.date,sum(number)over(partition by l.user_id order by l.date asc) as pc from
login l 
inner join  passing_number pn on l.user_id=pn.user_id and l.date=pn.date
inner join user u on l.user_id=u.id
order by l.date asc,u.name asc