년 월로 년 단위 일자 구하기 sql

SELECT
        YEAR
    ,    SUM (TABLEROW) AS SUMDAY
FROM
(
    SELECT
        *
    FROM
    (
        SELECT
            TO_CHAR(DT,'yyyy')||'년' AS YEAR,
            TO_CHAR(DT,'mm') AS MONTH,
            TO_CHAR(LAST_DAY(DT),'dd') AS TABLEROW
        FROM
        (
            SELECT
                TO_DATE(STARTDT,'yyyymm') + LEVEL - 1 AS DT
            FROM
            (
                SELECT
                    '2016'||'11' AS STARTDT,
                    '2017'||'12' AS ENDDT
                FROM
                    DUAL
            )--기준년도,기준요일
            CONNECT BY LEVEL <= TO_CHAR(LAST_DAY(TO_DATE(ENDDT, 'yyyymm')), 'ddd') - TO_CHAR(TRUNC(TO_DATE(STARTDT,'yyyymm'),'MM'),'ddd') + 1 + (365 * (TO_CHAR(LAST_DAY(TO_DATE(ENDDT, 'yyyymm')), 'yyyy') - TO_CHAR(TRUNC(TO_DATE(STARTDT, 'yyyymm'), 'MM'), 'yyyy')))
        )
        GROUP BY DT
        ORDER BY DT
    )
GROUP BY YEAR, MONTH, TABLEROW
ORDER BY YEAR, MONTH, TABLEROW
)
GROUP BY YEAR