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

select
    s.product_id,
    product_name,
    sum(quantity) as total_sales,
    max(quantity) as max_monthly_sales,
    min(quantity) as min_monthly_sales,
    round(avg(quantity), 0) as avg_monthly_sales
from
    sales_underline s
    left join products_underline p on s.product_id = p.product_id
where
    sale_month between '2024-01' and '2024-06'
group by
    product_id
order by
    product_id