sql script

select job, substring(date, 1, 7) as mon, sum(num) as cnt 
from resume_info
where date like '2025%'
group by job,substring(date, 1, 7)
order by substring(date, 1, 7) desc, cnt desc