题解 | #实习广场投递简历分析(一)#

关键：怎么表示2025年内，下面代码中展示了4中表示语法。

select job, sum(num) as cnt from resume_info 
where year(date) = '2025'
#where date LIKE '2025%'
#where date_format(date,'%Y')='2025'
#where date < '2026-01-01'and date > '2024-12-31' 
group by job 
order by cnt desc