LeetCode SQL 50

[IamShiwangi]

1204. Last Person to Fit in the Bus

[iamAntimPal]

# Write your MySQL query statement below
SELECT a.person_name
FROM
    Queue AS a,
    Queue AS b
WHERE a.turn >= b.turn
GROUP BY a.person_id
HAVING SUM(b.weight) <= 1000
ORDER BY a.turn DESC
LIMIT 1;

for expaltion go to Solution and Explaination

[IamShiwangi]

Thank you