题解 | 商品交易(网易校招笔试真题)
商品交易(网易校招笔试真题)
https://www.nowcoder.com/practice/f257dfc1b55e42e19eec004aa3cb4174
with
t1 as (
select
goods_id,
sum(count) total
from
trans
group by
goods_id
)
select
id,
name,
weight,
total
from
goods g
left join t1 on g.id = t1.goods_id
where
total > 20
and weight < 50
order by
id
