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

select a.job,a.mon as first_year_mon, a.cnt as first_year_cnt, b.mon as second_year_mon,b.cnt as second_year_cnt
from (select job,date_format(date,'%Y-%m') as mon,sum(num) as cnt 
	  from resume_info 
	  where year(date) = '2025'
	  group by job,mon 
	  order by mon desc,job desc) a
left join (select job,date_format(date,'%Y-%m') as mon, sum(num) as cnt 
		   from resume_info where year(date) = '2026'
		   group by job,mon 
		   order by mon desc,job desc) b 
		   on  a.job = b.job and right(a.mon,2)=right(b.mon,2)