VoLTE用户统计的8项指标SQL（中兴）

选出8项不是全0，也不是全1的用户。
会导致VoLTE无法正常使用。

    select * from
    (
    select m.IMSI,m.MSISDN,
    case M.VOLTE_TAG when 1 then 1 else 0 end VoLTE_Tag, 
    case PDN.PP when 1 then 1 else 0 end  PDN300,
    case M.TCSITPL when 10 then 1 else 0 end TCSI,
    case iFC.PP when 1 then 1 else 0 end iFC_OK,
    case STNSR.PP when 1 then 1 else 0 end STNSR_OK,
    case IMS.PP when 1 then 1 else 0 end IMS_OK,
    case TAS.PP when 1 then 1 else 0 end TAS_OK,
    case ENS.PP when 1 then 1 else 0 end ENS_OK
    from XZTE_HSS_2067_MAIN m,
    (
    select IMSI,1 PP from XZTE_HSS_2067_PDNT
    where EPCAPNTPLID=300
    ) PDN,
    (
    select distinct a.IMSI,1 PP from XZTE_HSS_2067_IMS a,XZTE_HSS_2067_IMPU b
    where a.IMSI=B.IMSI
    ) IMS,
    (
    select distinct IMSI,1 PP from XZTE_HSS_2067_IMPU
    where SIFCLIST like '%^100^%' and SIFCLIST like '%^200^%'
    ) iFC,
    (
    select IMSI,1 PP from XZTE_HSS_2067_MAIN
    where EPCSTNSR is not NULL
    ) STNSR,
    (
    select a.IMSI, 1 PP from XZTE_HSS_2067_MAIN a,XHWENS_2064_ENS b
    where a.msisdn=B.ENS_MSISDN
    ) ENS,
    (
    select distinct a.IMSI, 1 PP from XZTE_HSS_2067_MAIN a,XHWTASHB_2068_IMPU b
    where a.msisdn=B.msisdn
    ) TAS
    where M.IMSI=PDN.IMSI(+)
    and M.IMSI=IMS.IMSI(+) 
    and M.IMSI=iFC.IMSI(+) 
    and M.IMSI=STNSR.IMSI(+) 
    and M.IMSI=ENS.IMSI(+) --需要在ENS表的ENS_MSISDN字段加上索引
    and M.IMSI=TAS.IMSI(+)
    )
    where VoLTE_Tag+ PDN300+TCSI+IFC_OK+STNSR_OK+IMS_OK+TAS_OK+ENS_OK <8
    and VoLTE_Tag+ PDN300+TCSI+IFC_OK+STNSR_OK+IMS_OK+TAS_OK+ENS_OK >0