题解 | #实习广场投递简历分析(二)#

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