题解 | 实习广场投递简历分析(二)
实习广场投递简历分析(二)
https://www.nowcoder.com/practice/d323a4c97d1945e0aabe94e4d0bbb25d
注意身体，group by两个字段的先后顺序。
select
job,
date_format(date,'%Y-%m') as mon,
sum(num) as cnt
from resume_info
where date < '2026-01-01'
and date > '2024-12-31'
group by job,date_format(date,'%Y-%m')
order by mon desc, cnt desc;
查看24道真题和解析