题解 | #商品交易(网易校招笔试真题)#就是个阅读理解题
商品交易(网易校招笔试真题)
http://www.nowcoder.com/practice/f257dfc1b55e42e19eec004aa3cb4174
select * from (SELECT a.id,name,weight,sum(b.count) sum1 from goods as a join trans as b on a.id=b.goods_id where weight<50 group by a.id)c where sum1>20 order by id
