select a.SV_YEAR, a.PREFECTURE, a.KIND, a.AMT from
(
select
    ENROLLMENT_STATUS.PF_CODE,
    ENROLLMENT_STATUS.SURVEY_YEAR as SV_YEAR,
    PREFECTURE.PF_NAME as PREFECTURE,
    '小学校' as KIND,
    sum(ENROLLMENT_STATUS.ELEMENTARY) as AMT
from ENROLLMENT_STATUS
    left join PREFECTURE on PREFECTURE.PF_CODE = ENROLLMENT_STATUS.PF_CODE
    where SURVEY_YEAR = 2020
    group by ENROLLMENT_STATUS.PF_CODE
union all
select
    ENROLLMENT_STATUS.PF_CODE,
    ENROLLMENT_STATUS.SURVEY_YEAR as SV_YEAR,
    PREFECTURE.PF_NAME as PREFECTURE,
    '中学校' as KIND,
    sum(ENROLLMENT_STATUS.MIDDLE) as AMT
from ENROLLMENT_STATUS
    left join PREFECTURE on PREFECTURE.PF_CODE = ENROLLMENT_STATUS.PF_CODE
    where SURVEY_YEAR = 2020
    group by ENROLLMENT_STATUS.PF_CODE
union all
select
    ENROLLMENT_STATUS.PF_CODE,
    ENROLLMENT_STATUS.SURVEY_YEAR as SV_YEAR,
    PREFECTURE.PF_NAME as PREFECTURE,
    '高校' as KIND,
    sum(ENROLLMENT_STATUS.HIGH) as AMT
from ENROLLMENT_STATUS
    left join PREFECTURE on PREFECTURE.PF_CODE = ENROLLMENT_STATUS.PF_CODE
    where SURVEY_YEAR = 2020
    group by ENROLLMENT_STATUS.PF_CODE
union all
select
    ENROLLMENT_STATUS.PF_CODE,
    ENROLLMENT_STATUS.SURVEY_YEAR as SV_YEAR,
    PREFECTURE.PF_NAME as PREFECTURE,
    '短大' as KIND,
    sum(ENROLLMENT_STATUS.JUNIOR_CLG) as AMT
from ENROLLMENT_STATUS
    left join PREFECTURE on PREFECTURE.PF_CODE = ENROLLMENT_STATUS.PF_CODE
    where SURVEY_YEAR = 2020
    group by ENROLLMENT_STATUS.PF_CODE
union all
select
    ENROLLMENT_STATUS.PF_CODE,
    ENROLLMENT_STATUS.SURVEY_YEAR as SV_YEAR,
    PREFECTURE.PF_NAME as PREFECTURE,
    '大学' as KIND,
    sum(ENROLLMENT_STATUS.COLLEGE) as AMT
from ENROLLMENT_STATUS
    left join PREFECTURE on PREFECTURE.PF_CODE = ENROLLMENT_STATUS.PF_CODE
    where SURVEY_YEAR = 2020
    group by ENROLLMENT_STATUS.PF_CODE
union all
select
    ENROLLMENT_STATUS.PF_CODE,
    ENROLLMENT_STATUS.SURVEY_YEAR as SV_YEAR,
    PREFECTURE.PF_NAME as PREFECTURE,
    '大学院' as KIND,
    sum(ENROLLMENT_STATUS.GRADUATE) as AMT
from ENROLLMENT_STATUS
    left join PREFECTURE on PREFECTURE.PF_CODE = ENROLLMENT_STATUS.PF_CODE
    where SURVEY_YEAR = 2020
    group by ENROLLMENT_STATUS.PF_CODE
) as a
where AMT is not NULL
order by a.PF_CODE asc;