SELECT job, date_format(date,'%Y-%m') AS mon,
SUM(num) AS cnt
FROM resume_info ri
WHERE YEAR(date) = '2025'
GROUP BY job, mon
ORDER BY mon DESC, cnt DESC
SELECT job, date_format(date,'%Y-%m') AS mon,
SUM(num) AS cnt
FROM resume_info ri
WHERE YEAR(date) = '2025'
GROUP BY job, mon
ORDER BY mon DESC, cnt DESC