题解 | #商品交易(网易校招笔试真题)#
商品交易(网易校招笔试真题)
https://www.nowcoder.com/practice/f257dfc1b55e42e19eec004aa3cb4174
select id,name,weight,total from(select goods_id,sum(count) total from trans group by goods_id) t left join goods g on t.goods_id=g.id where total>20 and weight<50 order by id
投递腾讯等公司7个岗位 >
