题解 | 分析各产品线在特定时间段内的销售情况

SELECT a.product_line, b.region, b.channel_name,
    SUM(c.sale_amount) AS total_sale_amount,
    COUNT(c.product_id) AS total_sale_quantity
FROM oppo_products AS a
LEFT JOIN sales_data AS c
ON a.product_id = c.product_id
LEFT JOIN sales_channels AS b
ON b.channel_id = c.channel_id
GROUP BY a.product_line, b.region, b.channel_name
ORDER BY product_line;