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