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

select job,date_format(date,"%Y-%m") mon,sum(num) cnt
from resume_info
where year(date) = 2025
group by job,mon
order by mon desc,cnt desc