date_format函数的用法，其他没啥

select job,date_format(date,'%Y-%m') as mon,sum(num) as cnt
FROM resume_info
WHERE date LIKE "2025%"
GROUP BY job,mon
ORDER BY mon desc,cnt desc