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

select temp.job , first_year_mon,first_year_cnt,second_year_mon,second_year_cnt
from
(select job ,SUBSTRING(date,1,7) first_year_mon ,sum(num) first_year_cnt from resume_info
where SUBSTRING(date,1,4) = '2025'
group by job , first_year_mon
) temp
join
(select job ,SUBSTRING(date,1,7) second_year_mon ,sum(num) second_year_cnt from resume_info
where SUBSTRING(date,1,4) = '2026'
group by job , second_year_mon
) temp1
on substring(first_year_mon,6,2) = substring(second_year_mon,6,2) and temp.job = temp1.job
order by first_year_mon desc , job desc