题解 | 每个商品的销售总额
每个商品的销售总额
https://www.nowcoder.com/practice/6d796e885ee44a9cb599f47b16a02ea4
SELECT name product_name, total_sales, RANK()OVER(PARTITION BY category ORDER BY total_sales DESC) category_rank FROM (SELECT name, category, p.product_id, SUM(quantity) total_sales FROM products p JOIN orders o ON p.product_id = o.product_id GROUP BY name, category, p.product_id ) q1
不过你这绩点不考研浪费了吧