日期格式化函数：

select date_format(now(),'%Y-%m-%d %H:%i:%S');

结果：2017-10-29 14:02:54

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