SELECT TO_CHAR(A.INSERT_DATE,'MM' ) AS REQ_MONTH ,FUN_TCODE_NAME('B041', B.DEPT_CODE) AS DEPT_CODE ,A.LR_TYPE AS LR_TYPE ,A.LR_NAME AS LR_NAME ,A.REQUEST_MENO_OK AS REQUEST_MENO_NO ,TO_CHAR(A.INSERT_DATE, 'YYYY/MM/DD ') AS REQ_DATE ,NVL( (SELECT TO_CHAR(C.INSERT_DATE, 'YYYY/MM/DD ') AS RESPONSE_DATE FROM TLAWREVIEW C WHERE C.INSERT_ID =A.INSERT_ID AND DO_FLAG='50'),'미처리') AS RESP_DATE ,A.DO_FLAG ,NVL(((TO_CHAR(A.INSERT_DATE,'YYYYMMDD')) - (SELECT TO_CHAR(C.INSERT_DATE, 'YYYYMMDD ') AS RESPONSE_DATE FROM TLAWREVIEW C WHERE C.INSERT_ID =A.INSERT_ID AND DO_FLAG='50') ),'0') AS REP_CNT ,A.NOTE AS NOTE FROM TLAWREVIEW A ,TUSER B WHERE 1 = 1 AND A.INSERT_ID = B.USER_ID AND A.DO_FLAG IN ('30','50')
이 쿼리에서
REP_CNT 컬럼 평균, 합계 구하는데 몇시간째 삽질 중이네요..;
고수님들 좀 도와주세요~!!!