牛客987852806号

分类

题解(45)

/ 注册

全部文章（共1篇）

题解 | #商品交易(网易校招笔试真题)#小白做法，双表链接，提取题目要求的条件即可

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

Sqlite SqL

2021-10-08

1 484