题解 | 每个商品的销售总额

# 求出每个商品的销售总额
with t1 as(
select
name product_name,
o.product_id,
category,
sum(quantity)  total_sales
from orders o inner join products p on o.product_id = p.product_id
group by product_name,category,o.product_id
order by category,total_sales desc
)
#对总额按照分类排号
select product_name ,total_sales,
row_number() over(partition by category order by total_sales desc,product_id) category_rank
from t1