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

with tiaojian as (
select
job,
month(date) as months,
date_format(date,"%Y-%m") as month, 
sum(num) as cnt
from resume_info
where
year(date)=2025
group by job,date_format(date,"%Y-%m"),months 
) ,tiaojian1 as (
select
job,
month(date) as months,
date_format(date,"%Y-%m") as month, 
sum(num) as cnt
from resume_info
where
year(date)=2026
group by job,date_format(date,"%Y-%m") ,months
)



select 
t.job,
t.month,
t.cnt,
t1.month,
t1.cnt
from tiaojian t inner join tiaojian1 t1 on t.job=t1.job
and t.months=t1.months
order by t.month desc,t.job desc