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

select a.job, 
       a.year_mon first_year_mon, 
	   a.k first_year_cnt, 
	   b.year_mon second_year_mon, 
	   b.k second_year_cnt
from (select job, 
             date_format(date,'%Y-%m') year_mon, 
			 month(date) mon,
			 sum(num) k
			from resume_info
			where year(date) = '2025'
			GROUP BY job, year_mon) a
left join (select job, 
                  date_format(date,'%Y-%m') year_mon,
				  month(date) mon,
				  sum(num) k
			from resume_info
			where year(date) = '2026'
			GROUP BY job, year_mon) b
on a.job = b.job and a.mon = b.mon
order by first_year_mon desc,job desc