# 找到2025年每月的数据 with t1 as ( select id, job, date, num, DATE_FORMAT(date, '%Y-%m') as first_year_mon from resume_info where date between '2025-01-01' and '2025-12-31' ), t2 as ( select job, first_year_mon, sum(num) as first_year_cnt from t1 group by job, first_year_mon order by first_year_mon desc, j...