题解 | #商品交易(网易校招笔试真题)#
商品交易(网易校招笔试真题)
http://www.nowcoder.com/practice/f257dfc1b55e42e19eec004aa3cb4174
select s.goods_id, goods.name, goods.weight, total from (select goods_id, sum(count) total from trans group by goods_id having sum(count)>20) s left join goods on s.goods_id=goods.id where goods.weight<50 order by s.goods_id
投递字节跳动等公司10个岗位 >
