题解 | #实习广场投递简历分析(一)--时间查找#
实习广场投递简历分析(一)
http://www.nowcoder.com/practice/f5fc21a0630b4ca6a25ea3a48054ef47
select job,sum(num) as cnt from resume_info
where date between '2025-01-01' and '2025-12-31'
group by job
order by cnt desc;
like '2025%'
或
year(date) = 2025
或
between '2025-01-01' and '2025-12-31'
或
date >= '2025-01-01' and date <= '2025-12-31'
