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

select job,m,sum(num)
from (
select *,left(date,7) m
from resume_info
) t
where year(date)='2025'
group by job,m
order by m desc,sum(num) desc;