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

with a as (
    select product_id, sum(quarter_1_sales_amount)+sum(quarter_2_sales_amount)+sum(quarter_3_sales_amount)+sum(quarter_4_sales_amount) as sales
    from sales_info
    group by product_id
)
select product_id, product_name, competitor_name, sales as total_sales_amount_of_product, sales - total_competitor_sales_amount_2023 as sales_difference_with_competitor
from oppo_products_detail join a using(product_id) join competitor_analysis using(product_id)

闲的列名那么长