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

select product_id
,product_name
,competitor_name
,sum(quarter_1_sales_amount + quarter_2_sales_amount + quarter_3_sales_amount +quarter_4_sales_amount) as 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 as sales_difference_with_competitor
from oppo_products_detail
join sales_info using(product_id)
join competitor_analysis using(product_id)
group by product_id
,product_name
,competitor_name
,total_competitor_sales_amount_2023
order by product_id