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

select
table1.job
,table1.date 
,table1.cnt
,table2.date
,table2.cnt
from
(
select
job
,substring(date,1,7) date
,sum(num) cnt
from resume_info
where year(date) = '2025'
group by 1,2
)table1 left join
(
select
job
,substring(date,1,7) date
,sum(num) cnt
from resume_info
where year(date) = '2026'
group by 1,2
)table2 on table1.job = table2.job
and substring(table1.date,6,7) = substring(table2.date,6,7)
order by table1.date desc , job desc