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

  • 使用date_format得到需要的格式