题解 | 商品交易(网易校招笔试真题)
商品交易(网易校招笔试真题)
https://www.nowcoder.com/practice/f257dfc1b55e42e19eec004aa3cb4174
select g.id as goods_id,g.name,g.weight,sum(t.count) as total from trans as t left join goods as g on t.goods_id = g.id group by goods_id,g.name,g.weight having total>=20 and g.weight <50 order by goods_id asc
