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,
    SUM(AMT) AS 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 ELEMENTARY
            WHEN 2 THEN MIDDLE
            WHEN 3 THEN HIGH
            WHEN 4 THEN JUNIOR_CLG
            WHEN 5 THEN COLLEGE
            WHEN 6 THEN GRADUATE
            ELSE NULL
        END AS AMT
    FROM
        ENROLLMENT_STATUS AS ES
    CROSS JOIN
        SEQ_TBL
    WHERE
        SURVEY_YEAR = 2020
    ) AS ES
JOIN
    PREFECTURE AS PF
ON
    PF.PF_CODE = ES.PF_CODE
WHERE
    ES.AMT IS NOT NULL
GROUP BY
    PF.PF_CODE, SEQ_NO
ORDER BY
    ES.PF_CODE ASC,
    SEQ_NO ASC