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

注意只用两个表，题目指明又登陆没有刷题的情况不记

select g.name,t.date,sum(number) over(partition by g.name order by t.date asc) from passing_number as t join user as g on t.user_id=g.id order by t.date,g.name;