题解 | 每个商品的销售总额
每个商品的销售总额
https://www.nowcoder.com/practice/6d796e885ee44a9cb599f47b16a02ea4
SELECT
p.name AS product_name,
SUM(o.quantity) AS total_sales,
RANK() OVER(partition by p.category
order by SUM(o.quantity) DESC) AS category_rank
FROM products p
JOIN orders o USING (product_id)
GROUP BY p.name,RIGHT(category,1),p.product_id
ORDER BY category ASC,total_sales DESC,product_id ASC
查看14道真题和解析