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