SELECT
SURVEY_YEAR SV_YEAR,
PF_NAME PREFECTURE,
KIND,
SUM(AMT)
FROM (
SELECT SURVEY_YEAR,PF_CODE,AGE,ELEMENTARY AS AMT,'小学校' AS KIND, 0 AS KI FROM ENROLLMENT_STATUS WHERE ELEMENTARY > 0
UNION
SELECT SURVEY_YEAR,PF_CODE,AGE,MIDDLE AS AMT,'中学校' AS KIND, 1 AS KI FROM ENROLLMENT_STATUS WHERE MIDDLE > 0
UNION
SELECT SURVEY_YEAR,PF_CODE,AGE,HIGH AS AMT,'高校' AS KIND, 2 AS KI FROM ENROLLMENT_STATUS WHERE HIGH > 0
UNION
SELECT SURVEY_YEAR,PF_CODE,AGE,JUNIOR_CLG AS AMT,'短大' AS KIND, 3 AS KI FROM ENROLLMENT_STATUS WHERE JUNIOR_CLG > 0
UNION
SELECT SURVEY_YEAR,PF_CODE,AGE,COLLEGE AS AMT,'大学' AS KIND, 4  AS KI FROM ENROLLMENT_STATUS WHERE COLLEGE > 0
UNION
SELECT SURVEY_YEAR,PF_CODE,AGE,GRADUATE AS AMT,'大学院' AS KIND, 5 AS KI FROM ENROLLMENT_STATUS WHERE GRADUATE > 0
) S JOIN PREFECTURE USING(PF_CODE)
WHERE 				
SURVEY_YEAR = 2020
GROUP BY SURVEY_YEAR,PF_CODE,KIND
ORDER BY PF_CODE ASC, KI ASC