SELECT
    T.SURVEY_YEAR SV_YEAR,
    P.PF_NAME PREFECTURE,
    T.KIND,
    T.AMT
    
FROM
    (
    SELECT 1 SORT, "小学校" KIND, SUM(ELEMENTARY) AMT, PF_CODE,SURVEY_YEAR FROM
        ENROLLMENT_STATUS
        GROUP BY PF_CODE,SURVEY_YEAR
    UNION
        SELECT 2 SORT,"中学校" KIND, SUM(MIDDLE) AMT, PF_CODE,SURVEY_YEAR FROM
            ENROLLMENT_STATUS
        GROUP BY PF_CODE,SURVEY_YEAR
    UNION 
        SELECT 3 SORT, "高校" KIND, SUM(HIGH) AMT, PF_CODE,SURVEY_YEAR FROM
            ENROLLMENT_STATUS
        GROUP BY PF_CODE,SURVEY_YEAR
    UNION
        SELECT 4 SORT, "短大" KIND, SUM(JUNIOR_CLG) AMT, PF_CODE,SURVEY_YEAR FROM
            ENROLLMENT_STATUS
        GROUP BY PF_CODE,SURVEY_YEAR
    UNION
        SELECT 5 SORT, "大学" KIND, SUM(COLLEGE) AMT, PF_CODE,SURVEY_YEAR FROM
            ENROLLMENT_STATUS
        WHERE COLLEGE IS NOT NULL
        GROUP BY PF_CODE,SURVEY_YEAR
    UNION
        SELECT 6 SORT, "大学院" KIND, SUM(GRADUATE) AMT, PF_CODE,SURVEY_YEAR FROM
            ENROLLMENT_STATUS
        GROUP BY PF_CODE,SURVEY_YEAR
    ) T
    INNER JOIN PREFECTURE P ON T.PF_CODE = P.PF_CODE
WHERE T.SURVEY_YEAR = 2020 AND AMT IS NOT NULL
ORDER BY P.PF_CODE ASC,T.SORT ASC