题解 | 电商平台想要了解不同商品在不同月份的销售趋势

with t1 as 
(select 
    s.product_id,
    product_name,
    sale_month,
    sum(quantity) as sum_sales
from sales_underline s 
join products_underline p on s.product_id=p.product_id
where sale_month between '2024-01' and '2024-06'
group by product_id,product_name,sale_month)

select 
    product_id,
    product_name,
    sum(sum_sales) as total_sales,
    max(sum_sales) as max_monthly_sales,
    min(sum_sales) as min_monthly_sales,
    round(avg(sum_sales),0) as avg_monthly_sales
from t1
group by 1,2
order by 1;