select a.job,a.date as first_year_mon,a.hj as first_year_cnt,b.date as second_year_mon,b.hj2 as second_year_cnt from (select distinct job,date,coalesce(first_year_mon,second_year_mon) as hj -- 2025年 from ( select job,substr(date,1,7) as date,sum(case when substr(date,1,4) = '2025' then num end...