题解 | #实习广场投递简历分析(一)#
实习广场投递简历分析(一)
http://www.nowcoder.com/practice/f5fc21a0630b4ca6a25ea3a48054ef47
/*解法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;
MySQL试题答案解析 文章被收录于专栏
MySQL在线编程重点试题解析
查看1道真题和解析