题解 | #商品交易(网易校招笔试真题)#
商品交易(网易校招笔试真题)
http://www.nowcoder.com/practice/f257dfc1b55e42e19eec004aa3cb4174
明确问题：购买个数超过20，质量小于50的商品，按照商品id升序排序
首先要求和每个goods_id购买了多少个
首先要求和每个goods_id购买了多少个
- select goods_id,sum(count) total
- from trans
- group by goods_id
- select b.id,b.name,b.weight,a.total
- from (select goods_id,sum(count) total
- from trans
- group by goods_id) a
- join goods as b
- on a.goods_id=b.id
- where b.weight<50 and a.total>20
TCL华星光电公司福利 92人发布
