SELECT
    SURVEY_YEAR,
    PF_NAME,
    SUM(ELEMENTARY) AS AMT,
    '小学校' AS KIND
FROM ENROLLMENT_STATUS
WHERE SURVEY_YEAR = 2020
JOIN PREFECTURE USING(PF_CODE)
GROUP BY 1,2
UNION
SELECT
    SURVEY_YEAR,
    PF_NAME,
    SUM(MIDDLE) AS AMT,
    '中学校' AS KIND
FROM ENROLLMENT_STATUS
WHERE SURVEY_YEAR = 2020
JOIN PREFECTURE USING(PF_CODE)
GROUP BY 1,2

UNION
SELECT
    SURVEY_YEAR,
     PF_NAME,
    SUM(HIGH) AS AMT,
    '高校' AS KIND
FROM ENROLLMENT_STATUS
WHERE SURVEY_YEAR = 2020
GROUP BY 1,2
UNION
SELECT
    SURVEY_YEAR,
    PF_NAME,
    SUM(JUNIOR_CLG) AS AMT,
    '短大' AS KIND
FROM ENROLLMENT_STATUS
WHERE SURVEY_YEAR = 2020
GROUP BY 1,2
UNION
SELECT
    SURVEY_YEAR,
    PF_NAME,
    SUM(COLLEGE) AS AMT,
    '大学' AS KIND
FROM ENROLLMENT_STATUS
WHERE SURVEY_YEAR = 2020
GROUP BY 1,2
UNION
SELECT
    SURVEY_YEAR,
    PF_NAME,
    SUM(GRADUATE) AS AMT,
    '大学院' AS KIND
FROM ENROLLMENT_STATUS
WHERE SURVEY_YEAR = 2020
GROUP BY 1,2