优化mysql代码;SELECT 购买渠道,支付年月,子品牌, COUNT(DISTINCT `用户id`)购买人数, SUM( `商品实付金额` ) 购买金额 FROM ( SELECT `购买渠道`,`支付年月`,`子品牌`,`用户id`,`商品实付金额` FROM `valid_order` WHERE `支付日期` > DATE_SUB( '2023-03-31', INTERVAL 12 MONTH ) AND `支付日期` <= '2023-03-31' ) t GROUP BY 1,2,3 UNION ALL SELECT 购买渠道,支付年月,"合计" AS 子品牌, COUNT(DISTINCT `用户id`)购买人数, SUM( `商品实付金额` ) 购买金额 FROM ( SELECT `购买渠道`,`支付年月`,`用户id`,`商品实付金额` FROM `valid_order` WHERE `支付日期` > DATE_SUB( '2023-03-31', INTERVAL 12 MONTH ) AND `支付日期` <= '2023-03-31' ) t GROUP BY 1,2,3 UNION ALL SELECT 购买渠道,"合计" AS 支付年月,子品牌, COUNT(DISTINCT `用户id`)购买人数, SUM( `商品实付金额` ) 购买金额 FROM ( SELECT `购买渠道`,`子品牌`,`用户id`,`商品实付金额` FROM `valid_order` WHERE `支付日期` > DATE_SUB( '2022-03-31', INTERVAL 12 MONTH ) AND `支付日期` <= '2022-03-31' ) t GROUP BY 1,2,3 UNION ALL SELECT 购买渠道, "合计" AS 支付年月, "合计" AS 子品牌, COUNT(DISTINCT `用户id`)购买人数, SUM( `商品实付金额` ) 购买金额 FROM ( SELECT `购买渠道`,`用户id`,`商品实付金额` FROM `valid_order` WHERE `支付日期` > DATE_SUB( '2022-03-31', INTERVAL 2 MONTH ) AND `支付日期` <= '2022-03-31' ) t GROUP BY 1,2,3;