题解 | #创建一个actor_name表#
实习广场投递简历分析(二)
http://www.nowcoder.com/practice/d323a4c97d1945e0aabe94e4d0bbb25d
select
job,strftime('%Y-%m',date) as mon,sum(num) as cnt from resume_info
where
date >'2025-01-01' and date <'2025-12-31'
group by
job,mon
order by
mon desc, cnt desc ;
