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