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

select a.job, first_year_mon,first_year_cnt,second_year_mon,second_year_cnt
from (select job,substring(date,1,7) as first_year_mon,sum(num) as first_year_cnt
from resume_info
where year(date) = '2025'
group by job,first_year_mon
order by first_year_mon desc,job desc) as a
inner join 
(select job,substring(date,1,7) as second_year_mon,sum(num) as second_year_cnt
from resume_info
where year(date) = '2026'
group by job,second_year_mon
order by second_year_mon desc,job desc) as b
on a.job = b.job and substring(a.first_year_mon,6,2) = substring(b.second_year_mon,6,2)