WITH enroll_un as (
SELECT SURVEY_YEAR, PF_CODE, AGE, '小学校' AS key, ELEMENTARY AS value, 1 as ord FROM ENROLLMENT_STATUS
UNION ALL
SELECT SURVEY_YEAR, PF_CODE,AGE,  '中学校' AS key, MIDDLE AS value ,2 as ord FROM ENROLLMENT_STATUS
UNION ALL
SELECT SURVEY_YEAR,PF_CODE,AGE,   '高校' AS key, HIGH AS value ,3 as ord FROM ENROLLMENT_STATUS
UNION ALL
SELECT SURVEY_YEAR,PF_CODE,AGE,   '短大' AS key, JUNIOR_CLG AS value ,4 as ord  FROM ENROLLMENT_STATUS
UNION ALL
SELECT SURVEY_YEAR,PF_CODE,AGE,   '大学' AS key, COLLEGE AS value ,5 as ord FROM ENROLLMENT_STATUS
UNION ALL
SELECT SURVEY_YEAR,PF_CODE,AGE,   '大学院' AS key, GRADUATE AS value  ,6 as ord FROM ENROLLMENT_STATUS
)
SELECT
    e.SURVEY_YEAR as SV_YEAR,
    p.PF_NAME as PREFECTURE,
    e.key as KIND,
    SUM(e.value)  as AMT
FROM
    enroll_un as e
JOIN
    PREFECTURE as p
ON
    e.PF_CODE = p.PF_CODE
WHERE
    e.SURVEY_YEAR == '2019'
GROUP BY
    1, 2, 3
ORDER BY 
    e.PF_CODE ASC,
    e.ord asc