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

   select 
        product_id,
        product_name,
        competitor_name,
        sum(quarter_1_sales_amount + quarter_2_sales_amount + quarter_3_sales_amount  +quarter_4_sales_amount ) total_sales_amount_of_product,
        sum(quarter_1_sales_amount + quarter_2_sales_amount + quarter_3_sales_amount  +quarter_4_sales_amount )-total_competitor_sales_amount_2023 sales_difference_with_competitor
    from
        sales_info s1
    left join
        competitor_analysis s2
    using(product_id)
    left join
        oppo_products_detail s3
    using(product_id)

    group by 1,total_competitor_sales_amount_2023,2,3
    order by 1

全网最优雅的写法