Last Person to Fit in the Bus _ Medium. LeetCode

SELECT person_name
FROM Queue q1
JOIN (SELECT person_id,
    SUM(weight) OVER (ORDER BY turn) AS Total_Weight
FROM Queue
) q2
ON q1.person_id = q2.person_id
WHERE q2.Total_Weight <= 1000
ORDER BY Total_Weight DESC
LIMIT 1;