员工年龄分布报表统计（MySQL数据库开发）

最新推荐文章于 2023-03-29 09:56:04 发布

小洪鼠

最新推荐文章于 2023-03-29 09:56:04 发布

阅读量1.1k

点赞数 1

分类专栏：数据库

本文链接：https://blog.csdn.net/hsx15777894525/article/details/114832009

版权

数据库专栏收录该内容

15 篇文章 0 订阅

订阅专栏

业务场景：需要对系统中员工年龄分布进行数据统计分析。

select 
age_temp,
count(*) as total ,
CONCAT(round(count(*)/(select count(*)from people_baseinfo)*100,2),'%') as rate 
from (
		select age,
		case
		when age IS NULL OR age = '' then '未知'
		when age between 18 and 24 then '18-24岁'
		when age between 25 and 29 then '25-29岁'
		when age between 30 and 39 then '30-39岁'
		when age between 40 and 49 then '40-49岁'
		when age >49 then '50岁+'
		end as age_temp
		from people_baseinfo
		)t_user 
group by age_temp