题解 | #实习广场投递简历分析(三)# 没用join，借用了81题的思路

select 
    job,
    max(if(left(date, 4) = '2025', date, 0)) first_year_mon,
    max(if(left(date, 4) = '2025', cnt, 0)) first_year_cnt,
    max(if(left(date, 4) = '2026', date, 0)) second_year_mon,
    max(if(left(date, 4) = '2026', cnt, 0)) second_year_cnt
from (
    select job, date_format(date, '%Y-%m') date, sum(num) cnt
    from resume_info
    group by job, date_format(date, '%Y-%m')) t
group by job, right(date, 2)
order by first_year_mon desc, job desc