最简题解 | #实习广场投递简历分析(三)#
实习广场投递简历分析(三)
https://www.nowcoder.com/practice/83f84aa5c32b4cf5a75558d02dd7743c
直接按照月份group，然后按照条件求sum
select job ,concat('2025-',mon) as first_year_mon ,sum(case when year(date)=2025 then num else 0 end) as first_year_cnt ,concat('2026-',mon) as second_year_mon ,sum(case when year(date)=2026 then num else 0 end) as second_year_cnt from (select id,job,date,num,substr(date,6,2) as mon from resume_info) as t group by job,mon order by first_year_mon desc,job desc
查看14道真题和解析
