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

select p.name as product_name, sum(o.quantity) as total_sales,
       row_number() over(partition by p.category order by sum(o.quantity) desc, p.product_id asc ) as category_rank
from products p
         join orders o on o.product_id=p.product_id
group by p.category, p.product_id, p.name
order by p.category ASC,
         total_sales DESC,
         p.product_id ASC;