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

SELECT x.job, first_year_mon, first_year_cnt, second_year_mon, second_year_cnt FROM
(SELECT job, date, DATE_FORMAT(date, '%Y-%m') as first_year_mon, sum(num) as first_year_cnt
FROM resume_info
where year(date) = 2025
group by job, month(date)
order by first_year_mon DESC, job DESC) x
inner JOIN
(SELECT job, date, DATE_FORMAT(date, '%Y-%m') as second_year_mon, sum(num) as second_year_cnt
FROM resume_info
where year(date) = 2026
group by job, month(date)
order by second_year_mon DESC, job DESC) y
ON x.job = y.job
WHERE MONTH(x.date) = MONTH(y.date)