with uniontable
as (
SELECT
    e.survey_year as SV_YEAR
    ,p.pf_code
    ,p.pf_name as PREFECTURE
    ,'小学校'as KIND
    ,sum(e.elementary) as AMT
FROM enrollment_status e
Inner join prefecture p
    on p.pf_code = e.pf_code
where 
    survey_year = 2020
group by
    e.survey_year,p.pf_name

union all

SELECT
    e.survey_year as SV_YEAR
    ,p.pf_code
    ,p.pf_name as PREFECTURE
    ,'中学校'as KIND
    ,sum(e.middle) as AMT
FROM enrollment_status e
Inner join prefecture p
    on p.pf_code = e.pf_code
where 
    survey_year = 2020
group by
    e.survey_year,p.pf_name
    
union all

SELECT
    e.survey_year as SV_YEAR
    ,p.pf_code
    ,p.pf_name as PREFECTURE
    ,'高校'as KIND
    ,sum(e.high) as AMT
FROM enrollment_status e
Inner join prefecture p
    on p.pf_code = e.pf_code
where 
    survey_year = 2020
group by
    e.survey_year,p.pf_name

union all

SELECT
    e.survey_year as SV_YEAR
    ,p.pf_code
    ,p.pf_name as PREFECTURE
    ,'短大'as KIND
    ,sum(e.junior_clg) as AMT
FROM enrollment_status e
Inner join prefecture p
    on p.pf_code = e.pf_code
where 
    survey_year = 2020
group by
    e.survey_year,p.pf_name
    
union all

SELECT
    e.survey_year as SV_YEAR
    ,p.pf_code
    ,p.pf_name as PREFECTURE
    ,'大学'as KIND
    ,sum(e.college) as AMT
FROM enrollment_status e
Inner join prefecture p
    on p.pf_code = e.pf_code
where 
    survey_year = 2020
group by
    e.survey_year,p.pf_name

union all

SELECT
    e.survey_year as SV_YEAR
    ,p.pf_code
    ,p.pf_name as PREFECTURE
    ,'大学院'as KIND
    ,sum(e.graduate) as AMT
FROM enrollment_status e
Inner join prefecture p
    on p.pf_code = e.pf_code
where 
    survey_year = 2020
group by
    e.survey_year,p.pf_name
)

select
*
from uniontable
where amt is not null
order by 
    pf_code asc