题解 | #实习广场投递简历分析(二)#
实习广场投递简历分析(二)
http://www.nowcoder.com/practice/d323a4c97d1945e0aabe94e4d0bbb25d
select job,DATE_FORMAT(date,'%Y-%m') mon,sum(num) cnt
from resume_info
where year(date) = '2025'
group by job,mon
ORDER BY mon desc,cnt DESC
实习广场投递简历分析(二)
http://www.nowcoder.com/practice/d323a4c97d1945e0aabe94e4d0bbb25d
select job,DATE_FORMAT(date,'%Y-%m') mon,sum(num) cnt
from resume_info
where year(date) = '2025'
group by job,mon
ORDER BY mon desc,cnt DESC
相关推荐