题解 | #每个商品的销售总额#
每个商品的销售总额
https://www.nowcoder.com/practice/6d796e885ee44a9cb599f47b16a02ea4
SELECT p.name AS product_name,
SUM(o.quantity) AS total_sales,
ROW_NUMBER() OVER (PARTITION BY p.category ORDER BY SUM(o.quantity) DESC) AS category_rank
FROM orders AS o
JOIN products AS p
ON p.product_id = o.product_id
GROUP BY p.name, p.product_id
ORDER BY p.category, total_sales DESC, product_name, p.product_id;
网易游戏公司福利 643人发布
