题解 | #实习广场投递简历分析(三)#
实习广场投递简历分析(三)
https://www.nowcoder.com/practice/83f84aa5c32b4cf5a75558d02dd7743c
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;