SELECT '20101222' ACC_DAY, SUBSTR(A.AREA_ID, 1, 3) || 99 AREA_NO, COUNT(DISTINCT A.PROD_ID) EVDO_USER FROM NEW_SRC.PRODUCT A, NEW_SRC.CUSTOMER_FACING_SERV B, NEW_SRC.SERV_SPEC C WHERE A.PROD_ID = B.PROD_ID AND B.SERV_SPEC_ID = C.SERV_SPEC_ID AND C.SERV_SPEC_ID = 400 AND TO_CHAR(B.VERSION, 'YYYYMMDD') = '20101222' GROUP BY SUBSTR(A.AREA_ID, 1, 3) || 99
SUBSTR(A.AREA_ID, 1, 3) || 99 AREA_NO,
COUNT(DISTINCT A.PROD_ID) EVDO_USER
FROM NEW_SRC.PRODUCT A,
NEW_SRC.CUSTOMER_FACING_SERV B,
NEW_SRC.SERV_SPEC C
WHERE A.PROD_ID = B.PROD_ID
AND B.SERV_SPEC_ID = C.SERV_SPEC_ID
AND C.SERV_SPEC_ID = 400
AND TO_CHAR(B.VERSION, 'YYYYMMDD') = '20101222'
GROUP BY SUBSTR(A.AREA_ID, 1, 3) || 99