WITH SEQ_T AS (
    SELECT
        1 AS SEQ
    UNION ALL
    SELECT
        SEQ + 1 AS SEQ
    FROM
        SEQ_T
    WHERE
        SEQ < 6
)
SELECT
    SV_YEAR,
    PREFECTURE,
    KIND,
    AMT
FROM (
    SELECT
        E.SURVEY_YEAR SV_YEAR,
        P.PF_NAME PREFECTURE,
        (CASE SEQ_T.SEQ
            WHEN 1 THEN '小学校'
            WHEN 2 THEN '中学校'
            WHEN 3 THEN '高校'
            WHEN 4 THEN '短大'
            WHEN 5 THEN '大学'
            WHEN 6 THEN '大学院'
        END ) AS KIND,
        SUM(
            CASE SEQ_T.SEQ
                WHEN 1 THEN E.ELEMENTARY
                WHEN 2 THEN E.MIDDLE
                WHEN 3 THEN E.HIGH
                WHEN 4 THEN E.JUNIOR_CLG
                WHEN 5 THEN E.COLLEGE
                WHEN 6 THEN E.GRADUATE
            END
        ) AS AMT,
        P.PF_CODE,
        SEQ_T.SEQ
    FROM
        ENROLLMENT_STATUS E
    CROSS JOIN
        SEQ_T
    LEFT OUTER JOIN
        PREFECTURE P
    ON
        E.PF_CODE = P.PF_CODE
    WHERE
        E.SURVEY_YEAR = '2020'
    GROUP BY
        E.SURVEY_YEAR,
        P.PF_NAME,
        SEQ_T.SEQ
    ) T
WHERE
    T.AMT IS NOT NULL
ORDER BY
    T.PF_CODE ASC,
    T.SEQ ASC
;