Leetcode/sql/1204.sql at main · AF2B/Leetcode · GitHub

Name: Leetcode/sql/1204.sql at main · AF2B/Leetcode · GitHub
Rating: 4.7 (861 reviews)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
WITH OrderedQueue AS (
SELECT person_name, weight, turn
FROM Queue
ORDER BY turn
),
AccumulatedWeights AS (
SELECT person_name, weight,
SUM(weight) OVER (ORDER BY turn) AS total_weight
FROM OrderedQueue
)
SELECT person_name
FROM AccumulatedWeights
WHERE total_weight <=1000
ORDER BY total_weight DESC
LIMIT1;