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

select name product_name,
sum(quantity) total_sales,
row_number() over (partition by category order by sum(quantity) desc, product_id) category_rank
from orders o
join products p using (product_id)
group by product_id
order by category, total_sales desc