题解 | #实习广场投递简历分析(二)#
实习广场投递简历分析(二)
http://www.nowcoder.com/practice/d323a4c97d1945e0aabe94e4d0bbb25d
#第一步：筛选条件(2025年),并转换日期格式
#第二步：窗口函数：统计以月份为单位的投简历数量
SELECT id, job, DATE_FORMAT(DATE,"%Y-%m") "mon", num FROM resume_info WHERE YEAR(DATE)= 2025
#第二步：窗口函数：统计以月份为单位的投简历数量
SELECT DISTINCT job, mon, SUM(num) over(PARTITION BY job, mon) "cnt" FROM (SELECT id, job, DATE_FORMAT(DATE,"%Y-%m") "mon", num FROM resume_info WHERE YEAR(DATE)= 2025) t ORDER BY mon DESC, cnt DESC
查看28道真题和解析