SELECT
    X.SURVEY_YEAR AS SV_YEAR,
    P.PF_NAME AS PREFECTURE,
    X.KIND AS KIND,
    SUM(X.AMT) AS AMT
FROM
    (
        SELECT
            PF_CODE,
            SURVEY_YEAR,
            1 as b,
            '小学校' AS KIND,
            ELEMENTARY AS AMT
        FROM
            ENROLLMENT_STATUS
        UNION
        SELECT
            PF_CODE,
            SURVEY_YEAR,
            2 as b,
            '中学校' AS KIND,
            MIDDLE AS AMT
        FROM
            ENROLLMENT_STATUS
        UNION
        SELECT
            PF_CODE,
            SURVEY_YEAR,
            3 as b,
            '高校' AS KIND,
            HIGH AS AMT
        FROM
            ENROLLMENT_STATUS
        UNION
        SELECT
            PF_CODE,
            SURVEY_YEAR,
            4 as b,
            '短大' AS KIND,
            JUNIOR_CLG AS AMT
        FROM
            ENROLLMENT_STATUS
        UNION
        SELECT
            PF_CODE,
            SURVEY_YEAR,
            5 as b,
            '大学' AS KIND,
            COLLEGE AS AMT
        FROM
            ENROLLMENT_STATUS
        UNION
        SELECT
            PF_CODE,
            SURVEY_YEAR,
            6 as b,
            '大学院' AS KIND,
            GRADUATE AS AMT
        FROM
            ENROLLMENT_STATUS
    ) AS X
    LEFT JOIN PREFECTURE AS P ON 1 = 1
    AND X.PF_CODE = P.PF_CODE
where
    1 = 1
    AND X.SURVEY_YEAR = 2020
GROUP BY
    X.PF_CODE,
    X.KIND
HAVING
    SUM(X.AMT) IS NOT NULL
ORDER BY
    X.PF_CODE,
    X.b