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

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


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