17,086
社区成员
发帖
与我相关
我的任务
分享
with a as
(select '张三' name, '空洞' dept, 209 sal
from dual
union all
select '灭绝' name, '峨眉' dept, 253 sal
from dual
union all
select '李四' name, '空洞' dept, 271 sal
from dual
union all
select '令狐冲' name, '华山' dept, 932 sal
from dual
union all
select '岳灵珊' name, '华山' dept, 432 sal
from dual
union all
select '任盈盈' name, '华山' dept, 832 sal
from dual)
select count(distinct dept) 部门数量, count(distinct name) 人员数量, flag
from (select name,
dept,
case
when sal between 200 and 300 then
'200~300'
when sal between 301 and 500 then
'300~500'
else
'800以上'
end flag,
sal
from a)
group by flag