Leetcode Mysql 1204. 最后一个能进入电梯的人（DAY 10）

原题题目

代码实现（首刷自解）

# Write your MySQL query statement below
SELECT person_name
FROM  (SELECT person_name,SUM(weight) OVER(ORDER BY turn) AS sum_weightFROM queue) t
WHERE  t.sum_weight <= 1000
ORDER BY sum_weight DESC
LIMIT 1