SELECT job, substr(date, 1, 7) AS mon, sum(num) FROM resume_info WHERE substr(date, 1, 4) = '2025' GROUP BY substr(date, 1, 7), job ORDER BY substr(date, 1, 7) DESC, sum(num) DESC ;
SELECT job, substr(date, 1, 7) AS mon, sum(num) FROM resume_info WHERE substr(date, 1, 4) = '2025' GROUP BY substr(date, 1, 7), job ORDER BY substr(date, 1, 7) DESC, sum(num) DESC ;