题解 | #实习广场投递简历分析(二)#
实习广场投递简历分析(二)
https://www.nowcoder.com/practice/d323a4c97d1945e0aabe94e4d0bbb25d
SELECT
job,
substr(date, 1, 7) AS mon,
sum(num)
FROM
resume_info
WHERE
substr(date, 1, 4) = '2025'
GROUP BY
substr(date, 1, 7), job
ORDER BY
substr(date, 1, 7) DESC, sum(num) DESC
;
查看3道真题和解析