题解 | #实习广场投递简历分析(二)#
实习广场投递简历分析(二)
http://www.nowcoder.com/practice/d323a4c97d1945e0aabe94e4d0bbb25d
date_format函数的用法，其他没啥
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
