题解 | 每个商品的销售总额
每个商品的销售总额
https://www.nowcoder.com/practice/6d796e885ee44a9cb599f47b16a02ea4
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 as p
inner join orders as o
on p.product_id=o.product_id
group by p.product_id