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

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

对于'2020-03'

month(%Y-%m)输不出来值，但是可以用但是可以用right('2020-03',2)取月份