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

/*解法1
select job, sum(num) as cnt
from resume_info
where date >='2025-01-01'
and date <= '2025-12-31'
group by job
order by cnt desc;
*/
/*解法2
select job, sum(num) as cnt
from resume_info
where date like '2025%'
group by job
order by cnt desc;
*/
/*解法3
select job, sum(num) as cnt
from resume_info
where year(date) = 2025
group by job
order by cnt desc;
*/
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;