题解 | #商品交易(网易校招笔试真题)#
商品交易(网易校招笔试真题)
http://www.nowcoder.com/practice/f257dfc1b55e42e19eec004aa3cb4174
select g.id, g.name, g.weight, a.cnt from goods g left join (select t.goods_id,sum(t.count) as cnt from trans t group by t.goods_id)a on a.goods_id=g.id and a.cnt>20 where g.weight<50
老板电器公司氛围 197人发布
