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

主要是时间转换函数，转过来转过去弄的我脑壳大。。。。找工作

select r2.*,r4.second_year_mon,r4.second_year_cnt 
from (
    select job,first_year_mon,sum(num)first_year_cnt
      from (
          select job,date_format(date,'%Y-%m') as first_year_mon,num 
          from resume_info 
          where year(date)='2025')r1 
          group by job,first_year_mon
     )r2
LEFT JOIN
(select job,second_year_mon,sum(num)second_year_cnt
from (
    select job,date_format(date,'%Y-%m') as second_year_mon,num 
    from resume_info 
    where year(date)='2026')r3
    group by job,second_year_mon
)r4
on r2.job=r4.job 
and right(second_year_mon,2)=right(first_year_mon,2)
order by first_year_mon desc,job desc