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

select job,  date_format(date,'20%y-%m') as mon, sum(num) as cnt from resume_info
where year(date) = '2025'
group by job, month(date)
order by mon desc,cnt desc