题解 | #商品交易(网易校招笔试真题)#
商品交易(网易校招笔试真题)
https://www.nowcoder.com/practice/f257dfc1b55e42e19eec004aa3cb4174
with temp as ( select goods_id , sum(count) as v from trans group by goods_id having v > 20) select g.id, g.name,g.weight, temp.v from goods as g left join temp on g.id = temp.goods_id where g.weight <50
查看10道真题和解析
