dsfsfsdf

SELECT /*+parallel(x,4) parallel(y,4)*/  
       FIRST_LEVEL,
       FIRST_LEVEL_NAME,
       SECOND_LEVEL,
       SECOND_LEVEL_NAME,
       THREE_LEVEL,
       THREE_LEVEL_NAME,
       FOUR_LEVEL,
       FOUR_LEVEL_NAME,
       FIVE_LEVEL,
       FIVE_LEVEL_NAME,
       count(distinct case when x.acct_month_m = '201301' and 
                                Y.USER_NO is not null then 
                                x.user_no end),--1月发展在本月未出账用户
       count(distinct case when x.acct_month_m = '201301' then 
                                x.user_no end), --1月发展的用户
       0, --1月份发展本月流失率 
       
       
       
       /*CASE WHEN Y.USER_NO IS NOT NULL THEN '1'
            ELSE '0'
        END IS_NOT_ACCT*/
FROM KPI_M_2G_WASRATE_GRID_MID03 X,
(SELECT /*+PARALLEL(T,4)*/ T.* 
   FROM MID.MID_M_UE_G2_FLAG T 
  WHERE T.USER_TYPE_CODE <> '1' 
    AND NVL(T.IS_ACCT,'99') <> '1' 
    AND T.ACCT_MONTH = '201310') Y
 WHERE X.USER_NO = Y.USER_NO(+)
 group by FIRST_LEVEL,
       FIRST_LEVEL_NAME,
       SECOND_LEVEL,
       SECOND_LEVEL_NAME,
       THREE_LEVEL,
       THREE_LEVEL_NAME,
       FOUR_LEVEL,
       FOUR_LEVEL_NAME,
       FIVE_LEVEL,

       FIVE_LEVEL_NAME

--分类型出账用户
仿照 KPI.KPI_M_GRP_G2_DEV_01023
     KPI.p_KPI_M_GRP_G2_DEV_01023


     KPI.p_KPI_M_GRP_G2_DEV_ACCT