35 - 最后一个能进入巴士的人（高频 SQL 50 题基础版)

35 - 最后一个能进入巴士的人

-- sum(weight) over(order by turn) as total,根据turn升序，再求前面数的和
selectperson_name 
from(selectperson_name,sum(weight) over(order by turn) as totalfromQueue) new_Queue
wheretotal<=1000
order by total desc
limit 1;