# $1204. 最后一个能进入电梯的人
# https://leetcode-cn.com/problems/last-person-to-fit-in-the-bus/

# SQL架构
Create table If Not Exists Queue (person_id int, person_name varchar(30), weight int, turn int);
Truncate table Queue;
insert into Queue (person_id, person_name, weight, turn) values ('5', 'Alice', '250', '1');
insert into Queue (person_id, person_name, weight, turn) values ('4', 'Bob', '175', '5');
insert into Queue (person_id, person_name, weight, turn) values ('3', 'Alex', '350', '2');
insert into Queue (person_id, person_name, weight, turn) values ('6', 'John Cena', '400', '3');
insert into Queue (person_id, person_name, weight, turn) values ('1', 'Winston', '500', '6');
insert into Queue (person_id, person_name, weight, turn) values ('2', 'Marie', '200', '4');

# Write your MySQL query statement below
select
    q2.person_name
from
    Queue q1,
    Queue q2
where
    q1.turn <= q2.turn
group by
    q2.person_name,
    q2.person_id,
    q2.turn
having
    sum(q1.weight) <= 1000
order by
    q2.turn desc
limit
    1;

# clean-up
drop table Queue;