select b.job,b.first_year_mon,first_year_cnt, c.second_year_mon,c.second_year_cnt from ( select a.job, substr(a.date, 1, 7) as first_year_mon, sum(num) as first_year_cnt from resume_info a where a.date like '2025%' group by a.job, substr(a.date, 1, 7) ) b left join ( select a.job, substr(a.date, 1, ...