题解 | #商品交易(网易校招笔试真题)#
商品交易(网易校招笔试真题)
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
查看22道真题和解析
