WITH t AS (
    SELECT
        PF_CODE
        , SUM(ELEMENTARY) AS SUM_ELEMENTARY
        , SUM(MIDDLE) AS SUM_MIDDLE
        , SUM(HIGH) AS SUM_HIGH
        , SUM(JUNIOR_CLG) AS SUM_JUNIOR_CLG
        , SUM(COLLEGE) AS SUM_COLLEGE
        , SUM(GRADUATE) AS SUM_GRADUATE
    FROM
        ENROLLMENT_STATUS
    WHERE
        SURVEY_YEAR = 2020
    GROUP BY
        PF_CODE
)

SELECT
    2020 AS SV_YEAR
    , PF_NAME AS PREFECTURE
    , KIND
    , AMT
FROM
    (
    SELECT PF_CODE, 1 AS KIND_CODE, '小学校' AS KIND, SUM_ELEMENTARY AS AMT FROM t
    UNION
    SELECT PF_CODE, 2 AS KIND_CODE, '中学校' AS KIND, SUM_MIDDLE AS AMT FROM t
    UNION
    SELECT PF_CODE, 3 AS KIND_CODE, '高校' AS KIND, SUM_HIGH AS AMT FROM t
    UNION
    SELECT PF_CODE, 4 AS KIND_CODE, '短大' AS KIND, SUM_JUNIOR_CLG AS AMT FROM t
    UNION
    SELECT PF_CODE, 5 AS KIND_CODE, '大学' AS KIND, SUM_COLLEGE AS AMT FROM t
    UNION
    SELECT PF_CODE, 6 AS KIND_CODE, '大学院' AS KIND, SUM_GRADUATE AS AMT FROM t
    ) AS u
INNER JOIN
    PREFECTURE AS pf
ON
    u.PF_CODE = pf.PF_CODE
WHERE
    AMT IS NOT NULL
ORDER BY
    u.PF_CODE, KIND_CODE
;