select  X.SURVEY_YEAR as SV_YEAR,PF.PF_NAME AS PREFECTURE,KIND,SUM(AMT) AS AMT
FROM (
 select SURVEY_YEAR ,PF_CODE , '小学校' AS KIND , ELEMENTARY AS AMT, 1 AS SORTORDER FROM ENROLLMENT_STATUS WHERE ELEMENTARY > 0
 union all
 select SURVEY_YEAR ,PF_CODE , '中学校' AS KIND , MIDDLE AS AMT, 2 AS SORTORDER FROM ENROLLMENT_STATUS WHERE MIDDLE > 0
 union all
 select SURVEY_YEAR ,PF_CODE , '高校' AS KIND , HIGH AS AMT, 3 AS SORTORDER FROM ENROLLMENT_STATUS WHERE HIGH > 0
 union all
 select SURVEY_YEAR ,PF_CODE , '短大' AS KIND , JUNIOR_CLG AS AMT, 4 AS SORTORDER FROM ENROLLMENT_STATUS WHERE JUNIOR_CLG > 0
 union all
 select SURVEY_YEAR ,PF_CODE , '大学' AS KIND , COLLEGE AS AMT, 5 AS SORTORDER FROM ENROLLMENT_STATUS WHERE COLLEGE > 0
 union all
 select SURVEY_YEAR ,PF_CODE , '大学院' AS KIND , COLLEGE AS AMT, 6 AS SORTORDER FROM ENROLLMENT_STATUS WHERE GRADUATE > 0
)X
LEFT OUTER JOIN PREFECTURE PF ON (PF.PF_CODE = X.PF_CODE)
WHERE X.SURVEY_YEAR = 2020
GROUP BY SV_YEAR,PF_NAME,KIND
ORDER BY X.PF_CODE,X.SORTORDER