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