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

select job, sum(num) as cnt 
from resume_info
where date_format(date,'%Y')>2024 and date_format(date,'%Y')<=2025
group by job 
order by cnt desc