题解 | #实习广场投递简历分析(三)#

select mon25.job,mon25.mon fm,mon25.cnt fcnt,mon26.mon sm,mon26.cnt scnt
from (
select job,date_format(date,'%Y-%m') mon,sum(num) cnt
from resume_info
where year(date)=2025
group by mon,job ) mon25 inner join
(select job,date_format(date,'%Y-%m') mon,sum(num) cnt
from resume_info
where year(date)=2026
group by mon,job) mon26 on mon25.job=mon26.job and right(mon25.mon,2)=right(mon26.mon,2)
order by fm desc,mon25.job desc