题解 | 每个商品的销售总额
每个商品的销售总额
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
阿里云一面176人在聊
查看7道真题和解析