select t1.job, mon, sum(t1.num) as cnt from ( select job,date_format(date,'%Y-%m') as mon,num from resume_info where year(date)=2025 ) as t1 group by t1.job, mon order by mon desc, cnt desc;
select t1.job, mon, sum(t1.num) as cnt from ( select job,date_format(date,'%Y-%m') as mon,num from resume_info where year(date)=2025 ) as t1 group by t1.job, mon order by mon desc, cnt desc;