WITH RECURSIVE SEQ_TBL AS (
    SELECT
        1 AS SEQ_NO
    UNION ALL
    SELECT
        SEQ_NO + 1
    FROM
        SEQ_TBL
    WHERE
        SEQ_NO < 6
)
SELECT
    SURVEY_YEAR AS SUV_YEAR,
    PF_NAME AS PREFECTURE,
    KIND,
    AMT
FROM
    (
    SELECT
        SURVEY_YEAR,
        PF_CODE,
        SEQ_NO,
        CASE SEQ_NO
            WHEN 1 THEN '小学校'
            WHEN 2 THEN '中学校'
            WHEN 3 THEN '高校'
            WHEN 4 THEN '短大'
            WHEN 5 THEN '大学'
            WHEN 6 THEN '大学院'
            ELSE NULL
        END AS KIND,
        CASE SEQ_NO
            WHEN 1 THEN SUM(ELEMENTARY)
            WHEN 2 THEN SUM(MIDDLE)
            WHEN 3 THEN SUM(HIGH)
            WHEN 4 THEN SUM(JUNIOR_CLG)
            WHEN 5 THEN SUM(COLLEGE)
            WHEN 6 THEN SUM(GRADUATE)
            ELSE NULL
        END AS AMT
    FROM
        ENROLLMENT_STATUS AS ES
    CROSS JOIN
        SEQ_TBL
    WHERE
        SURVEY_YEAR = 2020
    GROUP BY
        PF_CODE, SEQ_NO
    ) AS ES
LEFT JOIN
    PREFECTURE AS PF
ON
    PF.PF_CODE = ES.PF_CODE
WHERE
    AMT IS NOT NULL
ORDER BY
    ES.PF_CODE ASC,
    SEQ_NO ASC