题解 | #商品交易(网易校招笔试真题)#
商品交易(网易校招笔试真题)
https://www.nowcoder.com/practice/f257dfc1b55e42e19eec004aa3cb4174
SELECT ta.goods_id AS id , goods.name AS name , goods.weight AS weight , total AS total FROM ( SELECT goods_id, sum(count) AS total FROM trans GROUP BY goods_id HAVING sum(count) > 20 ) AS ta JOIN goods ON ta.goods_id = goods.id WHERE goods.weight < 50