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

select t1.job,first_year_mon,first_year_cnt,second_year_mon,second_year_cnt from
(
    select job,date_format(date,"%Y-%m") first_year_mon,sum(num) first_year_cnt
    from resume_info
    WHERE DATE LIKE '2025%'
    GROUP BY job,first_year_mon
)t1
inner join(
    select job,date_format(date,"%Y-%m") second_year_mon,sum(num) second_year_cnt
    from resume_info
    WHERE DATE LIKE '2026%'
    GROUP BY job,second_year_mon
)t2
on t1.job=t2.job AND  right(first_year_mon,2)=right(second_year_mon,2)
order by first_year_mon DESC,t1.job DESC;