题解 | #商品交易(网易校招笔试真题)#
商品交易(网易校招笔试真题)
https://www.nowcoder.com/practice/f257dfc1b55e42e19eec004aa3cb4174
select a.goods_id id,g.name,g.weight,a.total from (select goods_id, sum(count) total from trans group by goods_id) a inner join goods g on g.id=a.goods_id where a.total>19 and g.weight<50 order by g.id
- 先聚合得到商品的销售数
- 然后连接表并进行筛选
华为开奖670人在聊