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