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

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

全部评论

相关推荐

评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客企业服务