题解 | 实习广场投递简历分析(二)
实习广场投递简历分析(二)
https://www.nowcoder.com/practice/d323a4c97d1945e0aabe94e4d0bbb25d
select
t1.job,
mon,
sum(t1.num) as cnt
from
(
select job,date_format(date,'%Y-%m') as mon,num from resume_info where year(date)=2025
) as t1
group by
t1.job,
mon
order by
mon desc,
cnt desc;
投递腾讯等公司6个岗位
查看14道真题和解析