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

Select t5.job, t5.month as 'first_year_mon', t5.num as 'first_year_cnt',
t6.month as 'second_year_mon', t6.num as 'second_year_cnt' 
From
(Select job, DATE_FORMAT(date,'%Y-%m') as month, Month(date) as m,sum(num) as num
From resume_info 
Where Year(date)=2025
Group By month,job
Order By month desc,job DESC)as t5
Join
(Select job, DATE_FORMAT(date,'%Y-%m') as month, Month(date) as m,sum(num) as num
From resume_info 
Where Year(date)=2026
Group By month,job
Order By month desc,job DESC)as t6
On t5.job=t6.job and t5.m=t6.m