SELECT resume_info.job,SUBSTRING(date,1,7),sum(distinct resume_info.num),second,sum(distinct b.num2) FROM resume_info,( select r1.job,SUBSTRING(date,1,7) second,sum(num) num2 FROM resume_info r1 WHERE YEAR(date) = '2026' group by job,SUBSTRING(date,1,7) ) b WHERE YEAR(date) = '2025' ...