题解 | #商品交易(网易校招笔试真题)#
商品交易(网易校招笔试真题)
https://www.nowcoder.com/practice/f257dfc1b55e42e19eec004aa3cb4174
select g.id, g.name, g.weight, (select sum(t.count) from trans t where g.id = t.goods_id) as total from goods g having total > 20 and g.weight < 50 order by 1 asc
经典子查询题目，select第一个第二个基本属性；后面的有个子查询，注意用Having，在聚合函数生效后进行过滤
查看8道真题和解析