题解 | 深入分析各款产品年总销售额与竞品的年度对比

select
    product_id,
    product_name,
    competitor_name,
    total_sales_amount_of_product,
    total_sales_amount_of_product - total_competitor_sales_amount_2023 as sales_difference_with_competitor
from
    (
        select
            product_id,
            sum(
                quarter_1_sales_amount + quarter_2_sales_amount + quarter_3_sales_amount + quarter_4_sales_amount
            ) as total_sales_amount_of_product
        from
            sales_info
        group by
            product_id
    ) as t
    join oppo_products_detail using (product_id)
    join competitor_analysis using (product_id)
order by product_id ASC;