题解 | 分析每个商品在不同时间段的销售情况

select
    product_id,
    product_name,
    sum(amount) as q2_2024_sales_total,
    rank() over (partition by category order by sum(amount) desc) as category_rank,
    supplier_name
from(
	select
		p.product_id,
		p.product_name,
		p.category,
		if(month(o.order_date) in (4, 5, 6), total_amount, 0) as amount,
		s.supplier_name
	from
		order_info o right join product_info p on o.product_id = p.product_id
		join supplier_info s on p.product_id = s.product_id) t
group by 
    product_id, product_name, supplier_name
order by
    product_id;