题解 | 实习广场投递简历分析(二)
实习广场投递简历分析(二)
https://www.nowcoder.com/practice/d323a4c97d1945e0aabe94e4d0bbb25d
select
job,
concat (year (date), '-', LPAD(MONTH(date), 2, '0')) as mon,
sum(num) as cnt
from
resume_info
where year(date) = 2025
group by
job,
mon
order by
mon desc,
cnt desc