题解 | #商品交易(网易校招笔试真题)#
商品交易(网易校招笔试真题)
https://www.nowcoder.com/practice/f257dfc1b55e42e19eec004aa3cb4174
# sum() 聚合函数真上头；
分两步做：一、先找出所有订单的购买数量；
二、与商品表内连接找出商品信息
select g.id,name,weight,t1.total
from
(select
distinct goods_id,sum(count) over(partition by goods_id) as total
from trans
) t1
join goods g
on t1.goods_id = g.id
where weight < 50 and total > 20
order by g.id
