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

select
*
from(
select
n.name
,l.date
,sum(p.number) over(partition by l.user_id order by l.date) s
from login l
join user n
on l.user_id = n.id
left join passing_number p
on l.user_id = p.user_id
and l.date = p.date
) a2
where a2.s is not null
order by a2.date,a2.name