1204. Last Person to Fit in the Bus : leetcode

-- turn으로 정렬
-- total_sum 컬럼 생성 - Recursive CTE?

WITH cte AS (SELECT  turn, person_name, weight,
            SUM(weight) OVER (ORDER BY turn) AS sequence_sum
            FROM    Queue),
    fin AS (SELECT  turn, person_name, sequence_sum
            FROM    cte
            WHERE   sequence_sum <= 1000) 

SELECT  person_name
FROM    fin
WHERE   turn = (SELECT MAX(turn) FROM fin)