题解 | #商品交易(网易校招笔试真题)#

select g.*,t.total
from 
(
select goods_id  ,sum(count) as total
from trans
group by goods_id  
having sum(count)>20 
) t 
join goods g 
on g.id=t.goods_id 
where g.weight<50