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