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

写一个错误答案 ，欢迎来找错误原因。

select ri.job   , substr(ri.date,1,7) as first_year_mon , sum(ri.num) as first_year_cnt

,substr(rn.date,1,7) as second_year_mon

,sum(rn.num) as second_year_cnt

from resume_info ri

 join resume_info rn

on ri.job = rn.job and month(ri.date) = month(rn.date)

where year(ri.date) = '2025' and year(rn.date) = '2026'

group by ri.job , substr(ri.date,1,7) , substr(rn.date,1,7)

order by substr(ri.date,1,7) desc,job desc