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