题解 | 每个商品的销售总额
每个商品的销售总额
https://www.nowcoder.com/practice/6d796e885ee44a9cb599f47b16a02ea4
select
p.name product_name,
sum(quantity) total_sales,
rank()over(partition by p.category order by p.category,sum(quantity) desc,p.product_id) category_rank
from products p join orders o using(product_id)
group by p.name, p.product_id,p.category #因为题目要求要按商品类别、还有商品id排序，所以要把这些也放到group by字段里
