实习广场投递简历分析(二)

简介

考察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;