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