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

select
    y1.job,
    first_year_mon,
    first_year_cnt,
    second_year_mon,
    second_year_cnt
from (
    select
        job,
        DATE_FORMAT(date,'%Y-%m') as first_year_mon,
        sum(num) as first_year_cnt 
    from resume_info
    where date like '2025%'
    group by job,DATE_FORMAT(date,'%Y-%m')
) as y1
join (
    select
        job,
        DATE_FORMAT(date,'%Y-%m') as second_year_mon,
        sum(num) as second_year_cnt
    from resume_info
    where date like '2026%'
    group by job,DATE_FORMAT(date,'%Y-%m')
) as y2
on y1.job = y2.job and right(first_year_mon,2)=right(second_year_mon,2)
order by first_year_mon desc, y1.job desc