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

select a.job,a.first_year_mon,a.first_year_cnt,b.second_year_mon,b.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
order by first_year_mon desc,first_year_cnt desc) a
inner 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
order by second_year_mon desc,second_year_cnt desc) b
on a.job=b.job
and right(a.first_year_mon,2)=right(b.second_year_mon,2)
order by first_year_mon desc,job desc

• 分别找出两年的相关数据
• 连接两个表
• 注意使用字符串截取函数right对比月份