相连的两表选取的年份不同,其他部分不变,创建临时表方便修改和阅读 with as 创建临时表 WITH r1 AS ( SELECT id, job, date, DATE_FORMAT(date, '%Y-%m') AS first_year_mon, SUM(num) AS first_year_cnt FROM resume_info WHERE date LIKE '2025%' GROUP BY job, first_year_mon ), r2 AS ( SELECT id, job, date, DATE_FORMAT(date, '%Y-%m') AS second_year...