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

SELECT
    op.product_line,
    sc.region,
    sc.channel_name,
    SUM(sd.sale_amount) AS total_sale_amount,
    COUNT(sd.sale_id) AS total_sale_quantity
FROM
    oppo_products AS op 
    INNER JOIN 
    sales_data AS sd ON op.product_id=sd.product_id
        INNER JOIN
        sales_channels AS sc ON sd.channel_id=sc.channel_id
GROUP BY
    op.product_line,
    sc.region,
    sc.channel_name,
    sc.channel_id
ORDER BY
    op.product_line,
    sc.channel_id