SELECT
     ES.SURVEY_YEAR AS SV_YEAR
    ,PR.PF_NAME     AS PREFECTURE
    ,ES.KIND        AS KIND
    ,ES.AMT         AS AMT
FROM
    (
               SELECT SURVEY_YEAR, PF_CODE, '0' AS KIND_PRI, '小学校' AS KIND, SUM(ELEMENTARY) AS AMT FROM ENROLLMENT_STATUS WHERE SURVEY_YEAR = 2020 GROUP BY SURVEY_YEAR, PF_CODE
     UNION ALL SELECT SURVEY_YEAR, PF_CODE, '1' AS KIND_PRI, '中学校' AS KIND, SUM(MIDDLE)     AS AMT FROM ENROLLMENT_STATUS WHERE SURVEY_YEAR = 2020 GROUP BY SURVEY_YEAR, PF_CODE
     UNION ALL SELECT SURVEY_YEAR, PF_CODE, '2' AS KIND_PRI, '高校'   AS KIND, SUM(HIGH)       AS AMT FROM ENROLLMENT_STATUS WHERE SURVEY_YEAR = 2020 GROUP BY SURVEY_YEAR, PF_CODE
     UNION ALL SELECT SURVEY_YEAR, PF_CODE, '3' AS KIND_PRI, '短大'   AS KIND, SUM(JUNIOR_CLG) AS AMT FROM ENROLLMENT_STATUS WHERE SURVEY_YEAR = 2020 GROUP BY SURVEY_YEAR, PF_CODE
     UNION ALL SELECT SURVEY_YEAR, PF_CODE, '4' AS KIND_PRI, '大学'   AS KIND, SUM(COLLEGE)    AS AMT FROM ENROLLMENT_STATUS WHERE SURVEY_YEAR = 2020 GROUP BY SURVEY_YEAR, PF_CODE
     UNION ALL SELECT SURVEY_YEAR, PF_CODE, '5' AS KIND_PRI, '大学院' AS KIND, SUM(GRADUATE)   AS AMT FROM ENROLLMENT_STATUS WHERE SURVEY_YEAR = 2020 GROUP BY SURVEY_YEAR, PF_CODE
    ) ES
    INNER JOIN PREFECTURE PR
    ON ES.PF_CODE = PR.PF_CODE
WHERE ES.AMT IS NOT NULL
ORDER BY ES.PF_CODE ASC, ES.KIND_PRI ASC