SELECT
    SURVEY_YEAR AS SV_YEAR,
    PF_NAME AS PREFECTURE,
    KIND,
    AMT
FROM(

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

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

UNION
SELECT
    SURVEY_YEAR,
     PF_NAME,
    '高校' AS KIND,
    SUM(HIGH) AS AMT
FROM ENROLLMENT_STATUS
JOIN PREFECTURE USING(PF_CODE)
WHERE SURVEY_YEAR = 2020
GROUP BY 1,2

UNION
SELECT
    SURVEY_YEAR,
    PF_NAME,
    '短大' AS KIND,
    SUM(JUNIOR_CLG) AS AMT
FROM ENROLLMENT_STATUS
JOIN PREFECTURE USING(PF_CODE)
WHERE SURVEY_YEAR = 2020
GROUP BY 1,2

UNION
SELECT
    SURVEY_YEAR,
    PF_NAME,
    '大学' AS KIND,
    SUM(COLLEGE) AS AMT
FROM ENROLLMENT_STATUS
JOIN PREFECTURE USING(PF_CODE)
WHERE SURVEY_YEAR = 2020
GROUP BY 1,2

UNION
SELECT
    SURVEY_YEAR,
    PF_NAME,
    '大学院' AS KIND,
    SUM(GRADUATE) AS AMT
FROM ENROLLMENT_STATUS
JOIN PREFECTURE USING(PF_CODE)
WHERE SURVEY_YEAR = 2020
GROUP BY 1,2

)
LEFT JOIN PREFECTURE USING(PF_NAME)
WHERE AMT > 0

ORDER BY PF_CODE,
  CASE KIND
  WHEN '小学校' THEN 1
  WHEN '中学校' THEN 2
  WHEN '高校' THEN 3
  WHEN '短大' THEN 4
  WHEN '大学' THEN 5
  WHEN '大学院' THEN 6
  END