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