题解 | #实习广场投递简历分析(二)#
实习广场投递简历分析(二)
http://www.nowcoder.com/practice/d323a4c97d1945e0aabe94e4d0bbb25d
select job, date_format(date,'20%y-%m') as mon, sum(num) as cnt from resume_info where year(date) = '2025' group by job, month(date) order by mon desc,cnt desc