就是一些常用函数的应用，熟练掌握就好。

select job, left(date,7) as mon, sum(num) as cnt
from resume_info
where year(date) = 2025
group by job, mon
order by mon desc, cnt desc;