题解 | #实习广场投递简历分析(二)#
实习广场投递简历分析(二)
https://www.nowcoder.com/practice/d323a4c97d1945e0aabe94e4d0bbb25d
select t1.job as job ,t1.mon as mon ,sum(t1.num) as cnt from ( select job ,DATE_FORMAT(date, '%Y-%m') as mon ,num from resume_info where date between '2025-01-01' and '2025-12-31' ) as t1 group by t1.job,t1.mon order by mon desc, cnt desc
查看13道真题和解析