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

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