题解 | 商品交易(网易校招笔试真题)
商品交易(网易校招笔试真题)
https://www.nowcoder.com/practice/f257dfc1b55e42e19eec004aa3cb4174
select g.id,g.name,g.weight,t.ct total from goods g join (select goods_id,sum(count) ct from trans group by goods_id having ct >20) t on t.goods_id = g.id where g.weight<50 order by g.id 如sql所示
海康威视公司福利 1409人发布
