代码:
from t1,t2 自连接 两两组合
group by + having 求和 选出<=1000的项
# Write your MySQL query statement below
select a.person_name
from Queue a, Queue b
where a.turn>=b.turn
group by a.person_id
having sum(b.weight)<=1000
order by a.turn desc
limit 1
代码:
from t1,t2 自连接 两两组合
group by + having 求和 选出<=1000的项
# Write your MySQL query statement below
select a.person_name
from Queue a, Queue b
where a.turn>=b.turn
group by a.person_id
having sum(b.weight)<=1000
order by a.turn desc
limit 1