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

select s.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,round(sum(quarter_1_sales_amount+quarter_2_sales_amount+quarter_3_sales_amount+quarter_4_sales_amount)-avg(total_competitor_sales_amount_2023),2) sales_difference_with_competitor
from sales_info s
join oppo_products_detail o using(product_id)
join competitor_analysis a using(product_id)
group by s.product_id,product_name,competitor_name