题解 | #实习广场投递简历分析(二)#
实习广场投递简历分析(二)
https://www.nowcoder.com/practice/d323a4c97d1945e0aabe94e4d0bbb25d
SELECT
job,
# LEFT(date, 7) AS mon,
DATE_FORMAT(date,'%Y-%m') AS mon,
SUM(num) AS cnt
FROM
resume_info
WHERE
# date LIKE '2025%'
LEFT(date, 4)='2025'
# YEAR(date)='2025'
GROUP BY
job, mon
ORDER BY
mon DESC, cnt DESC;
查看2道真题和解析
