题解 | #每个商品的销售总额#
每个商品的销售总额
https://www.nowcoder.com/practice/6d796e885ee44a9cb599f47b16a02ea4
select t1.product_name, t1.total_sales, row_number()over(partition by t1.category order by t1.total_sales desc) as category_rank from( select name as product_name, category, sum(quantity) as total_sales from orders join products using(product_id) group by name,category ) as t1
