题解 | #牛客每个人最近的登录日期(六)#
select user.name,b.date,b.ps_num from (select pn.user_id,pn.date,sum(pn2.number) as ps_num from passing_number pn inner join passing_number pn2 on pn.user_id==pn2.user_id and pn.date>=pn2.date group by pn.user_id,pn.date) as b left join user on b.user_id==user.id order by b.date,user.name