1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
select (1- (s1 + s2 + s3) / (s4 + s5 + s6))*100
from
(
select sum(v1) as s1 ,sum(v2) as s2,sum(v3) as s3,sum(v4) as s4,sum(v5) as s5,sum(v6) as s6
from (
select AVG(valeur)as v1,0 as v2,0 as v3,0 as v4,0 as v5,0 as v6 from MGW1 where indicateur like '%Vmgw%' and compteur = 'pmNrOfAal2TermsRej'
union
select 0,AVG(valeur),0,0,0,0 from MGW1 where indicateur like '%Vmgw%' and compteur = 'pmNrOfIpTermsRej'
union
select 0,0,AVG(valeur),0,0,0 from MGW1 where indicateur like '%TdmTermGrp%' and compteur = 'pmNrOfTdmTermsRej'
union
select 0,0,0,AVG(valeur),0,0 from MGW1 where indicateur like '%Vmgw%' and compteur = 'pmNrOfAal2TermsReq'
union
select 0,0,0,0,AVG(valeur),0 from MGW1 where indicateur like '%Vmgw%' and compteur = 'pmNrOfIpTermsReq'
union
select 0,0,0,0,0,AVG(valeur) from MGW1 where indicateur like '%TdmTermGrp%' and compteur = 'pmNrOfTdmTermsReq'
)) |
Partager