# 先查出2025年各个语言各个月的数据
select
a.job as job,
a.date1 as first_year_mon,
a.num as first_year_cnt,
b.date2 as second_year_mon,
b.num as second_year_cnt
from
(select
job,
substring(date,1,7) as date1,
sum(num) as num
from
resume_info
where year(date) = 2025
group by
job,substring(date,1,7)
order by 
date1 desc,job desc) a
inner join
(select
job,
substring(date,1,7) as date2,
sum(num) as num
from
resume_info
where year(date) = 2026
group by
job,substring(date,1,7)
order by 
date2 desc,job desc) b
on 
substring(a.date1,6,2) = substring(b.date2,6,2) and a.job = b.job