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

select temp25.job ,
temp25.first_year_mon  ,
temp25.first_year_cnt,
temp26.second_year_mon,
temp26.second_year_cnt
from (select job,substr(date,1,7)  as first_year_mon ,sum(num) as first_year_cnt from  resume_info where substr(date,1,4)='2025' group by job,first_year_mon) as temp25 
left join
(select job,substr(date,1,7) as second_year_mon ,sum(num) as second_year_cnt from resume_info where substr(date,1,4)='2026' group by job ,second_year_mon ) as temp26
on substr(temp25.first_year_mon,6,7)=substr(temp26.second_year_mon,6,7) and temp25.job=temp26.job   order by first_year_mon desc ,job desc;