SELECT
    e.SURVEY_YEAR AS SV_YEAR,
    p.PF_NAME AS PREFECTURE,
    z.KIND,
    SUM(z.AMT)
FROM PREFECTURE AS p
    INNER JOIN  ENROLLMENT_STATUS AS e ON p.PF_CODE = e.PF_CODE
    INNER JOIN 
    (SELECT e1.PF_CODE, '小学校' AS KIND, e1.ELEMENTARY AS AMT,1 AS sort FROM ENROLLMENT_STATUS AS e1
    UNION 
    SELECT e2.PF_CODE, '中学校' AS KIND, e2.ELEMENTARY AS AMT,2 AS sort FROM ENROLLMENT_STATUS AS e2
    UNION 
    SELECT e3.PF_CODE, '高校' AS KIND, e3.ELEMENTARY AS AMT,3 AS sort FROM ENROLLMENT_STATUS AS e3
    UNION 
    SELECT e2.PF_CODE, '短大' AS KIND, e2.ELEMENTARY AS AMT,4 AS sort FROM ENROLLMENT_STATUS AS e2
    UNION 
    SELECT e2.PF_CODE, '大学' AS KIND, e2.ELEMENTARY AS AMT,5 AS sort FROM ENROLLMENT_STATUS AS e2
    UNION 
    SELECT e2.PF_CODE, '大学院' AS KIND, e2.ELEMENTARY AS AMT,6 AS sort FROM ENROLLMENT_STATUS AS e2
    
    ) AS z ON p.PF_CODE = z.PF_CODE
    
WHERE e.SURVEY_YEAR = 2020
GROUP BY SV_YEAR, PREFECTURE, z.KIND
ORDER BY p.PF_CODE, z.sort