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

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

求问为什么我用窗口函数一直报错 是不是那里写错了?