题解 | #实习广场投递简历分析(二)#

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 
;