题解 | #实习广场投递简历分析(二)#
实习广场投递简历分析(二)
https://www.nowcoder.com/practice/d323a4c97d1945e0aabe94e4d0bbb25d
select job,left(date,7) as mon,sum(num) as cnt from resume_info where date between '2025-01-01' and '2025-12-31' group by job,left(date,7) order by mon desc,cnt desc