题解 | #实习广场投递简历分析(二)#
实习广场投递简历分析(二)
https://www.nowcoder.com/practice/d323a4c97d1945e0aabe94e4d0bbb25d
-- year(date)=2025也可以用left(date,4) ="2025"
-- 但是不能用substr(date,1,4)="2025"
select
job,
DATE_FORMAT (date, "%Y-%m") as mon,
sum(num) as cnt
from
resume_info
where
year(date)=2025
group by
job,
mon
order by
mon desc,
cnt desc ;
