SELECT
    E.SURVEY_YEAR AS SV_YEAR,
    PF.PF_NAME AS PREFECTURE,
    KIND,
    SUM(Students) AS AMT
FROM (
    SELECT SURVEY_YEAR, PF_CODE, '小学校' AS KIND, ELEMENTARY AS Students FROM ENROLLMENT_STATUS WHERE SURVEY_YEAR = 2020
    UNION ALL
    SELECT SURVEY_YEAR, PF_CODE, '中学校' AS KIND, MIDDLE AS Students FROM ENROLLMENT_STATUS WHERE SURVEY_YEAR = 2020
    UNION ALL
    SELECT SURVEY_YEAR, PF_CODE, '高校' AS KIND, HIGH AS Students FROM ENROLLMENT_STATUS WHERE SURVEY_YEAR = 2020
    UNION ALL
    SELECT SURVEY_YEAR, PF_CODE, '短大' AS KIND, JUNIOR_CLG AS Students FROM ENROLLMENT_STATUS WHERE SURVEY_YEAR = 2020
    UNION ALL
    SELECT SURVEY_YEAR, PF_CODE, '大学' AS KIND, COLLEGE AS Students FROM ENROLLMENT_STATUS WHERE SURVEY_YEAR = 2020
    UNION ALL
    SELECT SURVEY_YEAR, PF_CODE, '大学院' AS KIND, GRADUATE AS Students FROM ENROLLMENT_STATUS WHERE SURVEY_YEAR = 2020
) E
LEFT JOIN PREFECTURE PF ON E.PF_CODE = PF.PF_CODE
GROUP BY E.SURVEY_YEAR, PF.PF_NAME, KIND
ORDER BY E.PF_CODE,KIND