题解 | 每个商品的销售总额
每个商品的销售总额
https://www.nowcoder.com/practice/6d796e885ee44a9cb599f47b16a02ea4
select a.name as product_name,sum(b.quantity) as total_sales,
row_number() over(partition by a.category order by sum(b.quantity) desc) as category_rank from
products a join orders b on a.product_id=b.product_id
group by a.name,a.category
滴滴一面338人在聊