Sqlite 解法, 执行用时: 11ms, 内存消耗: 3304KB, 提交时间: 2021-07-27

-- 按月统计数量并排序
select job,substr(date,1,7) as mon,sum(num) as cnt
from resume_info
where date like '2025%'  -- 符合最左前缀匹配原则，也走索引
group by job,mon
order by mon desc,cnt desc

Sqlite 解法, 执行用时: 11ms, 内存消耗: 3368KB, 提交时间: 2021-09-07

select job, substr(date ,1,7) mon,sum(num) cnt
from resume_info
where date like '%2025%'
group by mon,job
order by mon desc,cnt desc
 

Sqlite 解法, 执行用时: 11ms, 内存消耗: 3372KB, 提交时间: 2022-02-21

select job, substr(date,0,8) as mon , sum(num) as cnt  from resume_info where date >= '2025-01-01' and date <'2026-01-01' group by job, mon order by mon desc , cnt desc 

Sqlite 解法, 执行用时: 11ms, 内存消耗: 3372KB, 提交时间: 2021-12-14

select job, strftime("%Y-%m", date) mon, sum(num) cnt
from resume_info
where date like '2025%'
group by job, mon
order by mon desc, cnt desc

Sqlite 解法, 执行用时: 11ms, 内存消耗: 3376KB, 提交时间: 2021-09-18

select 
    job,
    strftime('%Y-%m', date) mon,
    sum(num) cnt
from resume_info
where date like '2025%'
group by job, mon order by mon desc, cnt desc;