https://leetcode-cn.com/problems/last-person-to-fit-in-the-bus/

1204.png

with tmp as(
select person_name,turn,sum(weight) over(order by turn) leiji,(select max(turn) from Queue)mturn
    from Queue
group by person_name,turn
)

select * from(
select a.person_name
from tmp a,tmp b 
where a.turn<b.turn 
and   a.leiji<=1000 and b.leiji>1000 and a.turn<a.mturn
limit 1 
)a
union all 
select * from(
select a.person_name 
from tmp a
where a.turn=a.mturn and a.leiji<1000
)b