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