WITH t AS (
    SELECT 1 AS n
    UNION ALL
    SELECT n + 1
    FROM t
    WHERE n < 6
)
SELECT SV_YEAR,
    PREFECTURE,
    KIND,
    SUM(AMT)
FROM (
        SELECT SURVEY_YEAR SV_YEAR,
            PF_NAME PREFECTURE,
            CASE t.n
                WHEN 1 THEN '小学校'
                WHEN 2 THEN '中学校'
                WHEN 3 THEN '高校'
                WHEN 4 THEN '短大'
                WHEN 5 THEN '大学'
                WHEN 6 THEN '大学院'
                ELSE NULL
            END as KIND,
            CASE t.n
                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
                ELSE NULL
            END as AMT,
            p.PF_CODE PF_CODE,
            t.n n
        FROM ENROLLMENT_STATUS e
            INNER JOIN PREFECTURE p ON p.PF_CODE = e.PF_CODE
            CROSS JOIN t
            WHERE e.SURVEY_YEAR = 2020
    ) AS ESB
    WHERE ESB.AMT IS NOT NULL
    GROUP BY PREFECTURE,KIND
ORDER BY ESB.PF_CODE,
    ESB.n;