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

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

https://www.nowcoder.com/practice/f257dfc1b55e42e19eec004aa3cb4174

select  id,name,weight,total
from  goods  left join (
   select goods_id , sum(count) as total 
   from trans 
   group by goods_id
   having total  >20

)t  on  goods.id  = t.goods_id
where weight <50 
order by id

全部评论

相关推荐

评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客网在线编程
牛客网题解
牛客企业服务