题解 | #每个商品的销售总额#
每个商品的销售总额
https://www.nowcoder.com/practice/6d796e885ee44a9cb599f47b16a02ea4
select product_name,
sum(quantity) as total_sales,
rank() over(partition by category order by sum(quantity)desc) as category_rank
from(
select name as product_name,
category,
quantity
from products p
inner join orders o on p.product_id=o.product_id
) p_o
group by category,product_name
order by category,total_sales desc
深信服公司福利 734人发布