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