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

select job,sum(num) cnt 
from resume_info
where date>='2025-01-01' and date<='2025-12-31'
group by job
order by cnt desc

思路：对num进行一个求和，对job进行分组，排序也按求和后的cnt