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

select 
    i.product_id,
    p.product_name,
    c.competitor_name,
    sum(i.quarter_1_sales_amount+i.quarter_2_sales_amount+i.quarter_3_sales_amount+i.quarter_4_sales_amount) as total_sales_amount_of_product,
    sum(i.quarter_1_sales_amount+i.quarter_2_sales_amount+i.quarter_3_sales_amount+i.quarter_4_sales_amount)-c.total_competitor_sales_amount_2023 as sales_difference_with_competitor
 from sales_info i 
 left join oppo_products_detail p on i.product_id=p.product_id
 left join competitor_analysis c on i.product_id=c.product_id
 group by i.product_id,p.product_name,c.competitor_name,c.total_competitor_sales_amount_2023
 order by product_id