题解 | 商品交易(网易校招笔试真题)
select t.goods_id id,g.name name,g.weight weight,sum(t.count) total from trans t left join goods g on g.id=t.goods_id group by t.goods_id having sum(t.count)>20 and g.weight<50 order by t.goods_id
having 不是where
select t.goods_id id,g.name name,g.weight weight,sum(t.count) total from trans t left join goods g on g.id=t.goods_id group by t.goods_id having sum(t.count)>20 and g.weight<50 order by t.goods_id
having 不是where
相关推荐