题解 | #实习广场投递简历分析(二)#
实习广场投递简历分析(二)
http://www.nowcoder.com/practice/d323a4c97d1945e0aabe94e4d0bbb25d
select
a.job
,a.mon
,sum(a.num) r
from (
select
id
,job
,substring(date,1,7) mon
,num
from resume_info
where date >= '2025-01-01'
and date <= '2025-12-31'
) a
group by 1,2
order by a.mon desc,r desc