resume_info表
1、查询在2025年内投递简历的每个岗位,每一个月内收到简历的数量,并且按先按月份降序排序,再按简历数目降序排序
select job,date_format(date,'%Y-%m') as mon,sum(num) as cnt
from resume_info
where date like '2025%'
group by job,mon
order by mon desc,cnt desc
2、 查询在2025年3月份投递简历的每个岗位,再按简历数目降序排序
select job,mon,sum(num) as cnt
from (select job,date_format(date,'%Y-%03') as mon,num
from resume_info
where date like '2025-03%'
) as t1
group by job,mon
order by cnt desc
3、写出SQL语句查询在2025年内投递简历的岗位和数量,并且按数量降序排序
select job,sum(num) as cnt
from resume_info
where date>'2024-12-31' and date<'2026-01-01'
group by job
order by cnt desc