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

相关推荐

昨天 11:10
武汉纺织大学 C++
点赞 评论 收藏
分享

牛客热帖

更多
牛客网
牛客企业服务