题解 | #牛客的课程订单分析(三)#
实习广场投递简历分析(二)
http://www.nowcoder.com/practice/d323a4c97d1945e0aabe94e4d0bbb25d
select job,substring(date,1,7)as mon,sum(num) as num from resume_info where substring(date,1,4)='2025' group by job,substring(date,1,7) order by mon desc, num desc