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