LeetCode（数据库）- 最后一个能进入电梯的人

--解决方案(1)
SELECTa.person_nameFROMQueuea, QueuebWHEREa.turn>=b.turnGROUPBYa.person_idHAVINGSUM(b.weight) <=1000ORDERBYa.turnDESCLIMIT1--解决方案(2)
SELECTperson_nameFROM (
SELECT@sumn :=@sumn+weightper_sum, person_nameFROMQueue, (SELECT@sumn:=0) initORDERBYturn) RSWHEREper_sum<=1000ORDERBYper_sumDESCLIMIT1

SELECTRS.itemperson_nameFROM (
SELECT@flag:=falseflag, @sumn :=@sumn+IF(@sumn+weight<=1000, IF(@flag:=true, weight, 0), 0) per_sum, @item :=IF(@flag, person_name, @item) itemFROMQueue, (SELECT@sumn:=0, @item:=null, @flag:=false) initORDERBYturn) RSORDERBYRS.per_sumDESCLIMIT1