group by两个字段

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