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

select job, 
    DATE_FORMAT(date, '%Y-%m') mon,
    sum(num) cnt
from resume_info
where date like '2025%'
group by job, mon
order by mon desc, cnt desc