AAL2UP带宽拥塞和CID拥塞

这是爱立信的AAL2拥塞的提取脚本：
SELECT --date_id,--hour_id,
    rnc,MOID,PERIOD_DURATION,RBS,
--CLASS A
(sum( pmSuccInConnsRemoteQosClassA ) +sum( pmSuccOutConnsRemoteQosClassA) +sum( pmUnSuccInConnsLocalQosClassA) +sum( pmUnSuccInConnsRemoteQosClassA) +sum( pmUnSuccOutConnsLocalQosClassA) +sum( pmUnSuccOutConnsRemoteQosClassA)) as Attempts_ClassA,
(sum( pmUnSuccInConnsLocalQosClassA) +sum( pmUnSuccOutConnsLocalQosClassA)) as Congest_ClassA,
str((case when Congest_ClassA=0 then 0 else Congest_ClassA/Attempts_ClassA*100 end),8,4) as 'Congest_ClassA%',
(sum( pmUnSuccInConnsRemoteQosClassA) +sum( pmUnSuccOutConnsRemoteQosClassA)) as Aal2Fail_ClassA,
str((case when Aal2Fail_ClassA=0 then 0 else Aal2Fail_ClassA/Attempts_ClassA*100 end),8,4) as 'Aal2Fail_ClassA%',
--CLASS B
(sum( pmSuccInConnsRemoteQosClassB ) +sum( pmSuccOutConnsRemoteQosClassB) +sum( pmUnSuccInConnsLocalQosClassB) +sum( pmUnSuccInConnsRemoteQosClassB) +sum( pmUnSuccOutConnsLocalQosClassB) +sum( pmUnSuccOutConnsRemoteQosClassB)) as Attempts_ClassB,
(sum( pmUnSuccInConnsLocalQosClassB) +sum( pmUnSuccOutConnsLocalQosClassB)) as Congest_ClassB,
str((case when Congest_ClassB=0 then 0 else Congest_ClassB/Attempts_ClassB*100 end),8,4) as 'Congest_ClassB%',
(sum( pmUnSuccInConnsRemoteQosClassB) +sum( pmUnSuccOutConnsRemoteQosClassB)) as Aal2Fail_ClassB,
str((case when Aal2Fail_ClassB=0 then 0 else Aal2Fail_ClassB/Attempts_ClassB*100 end),8,4) as 'Aal2Fail_ClassB%',
--CLASS C
(sum( pmSuccInConnsRemoteQosClassC ) +sum( pmSuccOutConnsRemoteQosClassC) +sum( pmUnSuccInConnsLocalQosClassC) +sum( pmUnSuccInConnsRemoteQosClassC) +sum( pmUnSuccOutConnsLocalQosClassC) +sum( pmUnSuccOutConnsRemoteQosClassC)) as Attempts_ClassC,
(sum( pmUnSuccInConnsLocalQosClassC) +sum( pmUnSuccOutConnsLocalQosClassC)) as Congest_ClassC,
str((case when Congest_ClassC=0 then 0 else Congest_ClassC/Attempts_ClassC*100 end),8,4) as 'Congest_ClassC%',
(sum( pmUnSuccInConnsRemoteQosClassC) +sum( pmUnSuccOutConnsRemoteQosClassC)) as Aal2Fail_ClassC,
str((case when Aal2Fail_ClassC=0 then 0 else Aal2Fail_ClassC/Attempts_ClassC*100 end),8,4) as 'Aal2Fail_ClassC%',
--CLASS D
(sum( pmSuccInConnsRemoteQosClassD ) +sum( pmSuccOutConnsRemoteQosClassD) +sum( pmUnSuccInConnsLocalQosClassD) +sum( pmUnSuccInConnsRemoteQosClassD) +sum( pmUnSuccOutConnsLocalQosClassD) +sum( pmUnSuccOutConnsRemoteQosClassD)) as Attempts_ClassD,
(sum( pmUnSuccInConnsLocalQosClassD) +sum( pmUnSuccOutConnsLocalQosClassD)) as Congest_ClassD,
str((case when Congest_ClassD=0 then 0 else Congest_ClassD/Attempts_ClassD*100 end),8,4) as 'Congest_ClassD%',
(sum( pmUnSuccInConnsRemoteQosClassD) +sum( pmUnSuccOutConnsRemoteQosClassD)) as Aal2Fail_ClassD,
str((case when Aal2Fail_ClassD=0 then 0 else Aal2Fail_ClassD/Attempts_ClassD*100 end),8,4) as 'Aal2Fail_ClassD%',
--CLASS ALL
Attempts_ClassA+Attempts_ClassB+Attempts_ClassC+Attempts_ClassD as Aal2_Attempts,
Congest_ClassA + Congest_ClassB+Congest_ClassC+Congest_ClassD as Aal2_Congest,
str((case when Aal2_Congest=0 then 0 else Aal2_Congest/Aal2_Attempts*100 end),8,4) as 'Congest_Class%',
Aal2Fail_ClassA + Aal2Fail_ClassB+Aal2Fail_ClassC+Aal2Fail_ClassD as Aal2_Fail,
str((case when Aal2_Fail=0 then 0 else Aal2_Fail/Aal2_Attempts*100 end),8,4) as 'Aal2Fail_Class%',
sum(pmExisOrigConns ) as  ExisOrigConns,
sum(pmExisTermConns)  as ExisTermConns,
sum(pmExisTransConns) as ExisTransConns

FROM DC_E_CPP_AAL2AP_RAW
WHERE RNC LIKE '**rnc%'
--and rbs  like '%0587%'
and DATE_ID between  '20130512' and  '20130512'
--and DATE_ID =  '20121119'
--and hour_id in (20,22)

GROUP BY --date_id,--hour_id,
    rnc,MOID,PERIOD_DURATION,RBS
ORDER BY --date_id,--hour_id,
    rnc,MOID,PERIOD_DURATION,RBS