select 2025job as job, concat(substring(monnum1, 1, 4), '-', substring(monnum1, 5, 6)) as first_year_mon, cnt_1 as first_year_cnt, concat(substring(monnum2, 1, 4), '-', substring(monnum2, 5, 6)) as second_year_cnt, cnt_2 as second_year_cnt from (select t3.job as 2025job, t3.monnum1, t3.cnt_1, t4.job...