自学SQL-lesson 10 统计1-练习5答案

原题5：就职1,3,5,7年的人分别占总人数的百分比率是多少(给出年份和比率"50%" 记为 50)

给大家个参考吧，度娘了好多都不能判定正确。

原表：Employees

Role	Name	Building	Years_employed
Engineer	Becky A.	1e	4
Engineer	Dan B.	1e	2
Engineer	Sharon F.	1e	6
Engineer	Dan M.	1e	4
Engineer	Sharon F.	1e	6
Engineer	Malcom S.	1e	1
Artist	Tylar S.	2w	2
Artist	Sherman D.	2w	8
Artist	Jakob J.	2w	6
Artist	Lillia A.	2w	7
Artist	Brandon J.	2w	7
Manager	Scott K.	1e	9
Manager	Shirlee M.	1e	3
Manager	Daria O.	2w	6
Engineer	Yancy I.	null	0
Artist	Oliver P.	null	0

自己摸索的答案（和大多数人一样）但结果没有判定正确：

select Years_employed,count(*)*100/(select count(*) from employees) as rate
from employees 
where Years_employed in(1,3,5,7) 
group by years_employed

显示结果：

Years_employed	Rate
1	6
3	6
7	13

系统给出的答案：

SELECT Years_employed,round(count(*)*1.0*100/(select count(*) from employees)) as rate
FROM employees
where Years_employed in(1,3,5,7)
group by Years_employed

显示结果:

Years_employed	Rate
1	7
3	7
7	13