3,491
社区成员
发帖
与我相关
我的任务
分享
Select A.StartTime as 时间分组,A.Counts 呼入总次数,nvl(B.Counts,0) 成功总次数,nvl(C.Counts,0) 失败总次数,
nvl(D.Counts,0) 转人工总次数,nvl(E.Counts,0) 转人工成功次数,
case
when nvl(D.Counts,0)=0 then 0 else nvl(E.Counts,0)*100/D.Counts end as 转人工接通率(100%) --未找到from语句
else (nvl(D.Counts,0)-nvl(E.Counts,0)) as 转人工失败次数
endfrom
(select count(*) from *** )A left outer join
(select count(*) from *** )B left outer join
(select count(*) from *** )C left outer join
(select count(*) from *** )D left outer join
(select count(*) from *** )E left outer join
Select A.StartTime as 时间分组,A.Counts 呼入总次数,nvl(B.Counts,0) 成功总次数,nvl(C.Counts,0) 失败总次数,
nvl(D.Counts,0) 转人工总次数,nvl(E.Counts,0) 转人工成功次数,
case
when nvl(D.Counts,0)=0 then nvl(E.Counts,0)*100/D.Counts as 转人工接通率(100%)
else (nvl(D.Counts,0)-nvl(E.Counts,0)) as 转人工失败次数
end
from
else nvl(E.Counts,0)*100/D.Counts end as 转人工接通率(100%)
Select A.StartTime as 时间分组,A.Counts 呼入总次数,nvl(B.Counts,0) 成功总次数,nvl(C.Counts,0) 失败总次数,
nvl(D.Counts,0) 转人工总次数,nvl(E.Counts,0) 转人工成功次数,
case
when nvl(D.Counts,0)=0 then nvl(E.Counts,0)*100/D.Counts as 转人工接通率(100%)
else nvl(E.Counts,0)*100/D.Counts end as 转人工接通率(100%)
else (nvl(D.Counts,0)-nvl(E.Counts,0)) as 转人工失败次数
end
from
(select count(*) as Counts from *** )A left outer join
(select count(*) as Counts from *** )B left outer join
(select count(*) as Counts from *** )C left outer join
(select count(*) as Counts from *** )D left outer join
(select count(*) as Counts from *** )E left outer join
Select A.StartTime as 时间分组,A.Counts 呼入总次数,nvl(B.Counts,0) 成功总次数,nvl(C.Counts,0) 失败总次数,
nvl(D.Counts,0) 转人工总次数,nvl(E.Counts,0) 转人工成功次数,
case
when nvl(D.Counts,0)=0 then as--缺失关键字 转人工接通率(100%)(100%)
else (nvl(D.Counts,0)-nvl(E.Counts,0)) as 转人工失败次数
endfrom
(select count(*) from *** )A left outer join
(select count(*) from *** )B left outer join
(select count(*) from *** )C left outer join
(select count(*) from *** )D left outer join
(select count(*) from *** )E left outer join