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

SELECT resume_info.job,SUBSTRING(date,1,7),sum(distinct resume_info.num),second,sum(distinct b.num2)
FROM resume_info,(
    select r1.job,SUBSTRING(date,1,7) second,sum(num) num2
    FROM resume_info r1
    WHERE YEAR(date) = '2026'
    group by job,SUBSTRING(date,1,7)
) b
WHERE YEAR(date) = '2025' and b.job = resume_info.job and b.second = SUBSTRING(DATE_ADD(date,INTERVAL 1 YEAR),1,7)
group by resume_info.job,SUBSTRING(date,1,7)
order by SUBSTRING(date,1,7) desc,job desc