SELECT
    job,
    # LEFT(date, 7) AS mon,
    DATE_FORMAT(date,'%Y-%m') AS mon,
    SUM(num) AS cnt
FROM
    resume_info
WHERE
    # date LIKE '2025%'
    LEFT(date, 4)='2025'
    # YEAR(date)='2025'
GROUP BY
    job, mon
ORDER BY
    mon DESC, cnt DESC;