select table1.job ,table1.date ,table1.cnt ,table2.date ,table2.cnt from ( select job ,substring(date,1,7) date ,sum(num) cnt from resume_info where year(date) = '2025' group by 1,2 )table1 left join ( select job ,substring(date,1,7) date ,sum(num) cnt from resume_info where year(date) = '2026' gro...