1. 휴일 테이블은 전체 날짜가 들어있나요?

2. 휴일 몇일전에 설날에는 데이타가 3이 왜들어있나요? 뒤로가면 줄고... 휴일수인가요?

3. 휴일 몇일후는 데이터가 맞나요? 

-- 오늘따라 바빠서 일단 휴가 몇일전인지

WITH CALENDAR (SUN_DT,MOON_DT) AS (
SELECT '19000129' , '18991229' FROM DUAL UNION ALL
SELECT '19000130' , '18991230' FROM DUAL UNION ALL
SELECT '19000131' , '19000101' FROM DUAL UNION ALL
SELECT '19000201' , '19000102' FROM DUAL UNION ALL
SELECT '19000202' , '19000103' FROM DUAL UNION ALL
SELECT '19000203' , '19000105' FROM DUAL UNION ALL
SELECT '19000204' , '19000106' FROM DUAL 
) , HOLIDAY ( SUN_DT , HOLIDAY_YN ) AS (
SELECT '19000131' , 'Y' FROM DUAL
)

SELECT SUN_DT 
     , MOON_DT
     , DY
     , COUNT(*) OVER(PARTITION BY GB ORDER BY SUN_DT DESC ) BF_HOLIDAY_CNT
  FROM (SELECT A.SUN_DT 
             , A.MOON_DT 
             , TO_CHAR(TO_DATE(A.SUN_DT,'YYYYMMDD'),'DAY') DY  
             , SUM(1+CASE WHEN TO_CHAR(TO_DATE(A.SUN_DT,'YYYYMMDD'),'D') IN ( 1 , 7 ) THEN 1 WHEN B.HOLIDAY_YN = 'Y' THEN 1 END ) OVER(ORDER BY A.SUN_DT) GB
             , ROW_NUMBER() OVER(ORDER BY A.SUN_DT) RN
          FROM CALENDAR A
             , HOLIDAY B
         WHERE A.SUN_DT = B.SUN_DT(+)
        )
  ORDER BY SUN_DT