SELECT resume_2025.*, resume_2026.mon, resume_2026.num FROM ( SELECT job, substr(date, 1, 7) AS mon, sum(num) AS num FROM resume_info WHERE substr(date, 1, 4) = '2025' GROUP BY job, substr(date, 1, 7) ) AS resume_2025 LEFT OUTER JOIN ( SELECT job, substr(date, 1, 7) AS mon, sum(num) AS num FROM resume_info WHERE substr(date, 1, 4) = '2026' GROUP BY job, substr(date, 1, 7) ) AS resume_2026 ON resume_2025.job = resume_2026.job AND SUBSTR(resume_2025.mon, 6,2)= SUBSTR(resume_2026.mon, 6,2) ORDER BY resume_2025.mon DESC , resume_2025.job DESC