select product_id,product_name,competitor_name, total_sales_amount_2023 as total_sales_amount_of_product, (total_sales_amount_2023-total_competitor_sales_amount_2023) as sales_difference_with_competitor from oppo_products_detail left join ( select product_id, sum(quarter_1_sales_amount+quarter_2_sal...