# 表意不明的一条题目
select
    g.id,
    g.name,
    g.weight,
    sum(t.count) as total
from 
    goods g inner join trans t
    on g.id = t.goods_id
group by t.goods_id
having total > 20 and g.weight < 50
order by g.id
;