简介
考察DATE_FORMAT 与 group 联立 order by 联立
select job, DATE_FORMAT(date, ‘%Y-%m‘) as mon, sum(num) as cnt from resume_info where date like ‘2025%‘ group by job,mon order by mon desc, cnt desc;
实习广场投递简历分析(二)
原文:https://www.cnblogs.com/eat-too-much/p/14958193.html