题解 | #商品交易(网易校招笔试真题)#
商品交易(网易校招笔试真题)
https://www.nowcoder.com/practice/f257dfc1b55e42e19eec004aa3cb4174
select t2.goods_id, t1.name, t1.weight, sum(t2.count) from goods t1 join trans t2 on t1.id = t2.goods_id group by t2.goods_id,t1.name,t1.weight having t1.weight >= 20 and t1.weight < 50 order by t2.goods_id;
查看12道真题和解析