SELECT product_type,'合计' AS responsibility_category,SUM(returned_quantity) AS exodus_rate,YEAR(order_payment_time) AS year,MONTH(order_payment_time) AS month FROM various_responsibilities WHERE order_payment_time between date_sub('2022-10-12',interval 4 month) and '2022-10-12' AND branch_date<='2022-10-12' GROUP BY product_type,year,month ) C LEFT JOIN( SELECT product_type,SUM(sales_volume) AS exodus_rate,YEAR(order_payment_time) AS year,MONTH(order_payment_time) AS month FROM various_responsibilities WHERE order_payment_time between date_sub('2022-10-12',interval 4 month) and '2022-10-12' AND branch_date<='2022-10-12' GROUP BY product_type,year,month) D ON C.product_type=D.product_type AND C.year=D.year AND C.month=D.month |