select
a.SURVEY_YEAR as SV_YEAR,
b.PF_NAME as PREFECTURE,
a.KIND,
a.AMT
from 
(
select
 SURVEY_YEAR,
 PF_CODE,
 '1' as num,
 '小学校' as KIND,
 SUM(ELEMENTARY) as AMT
from ENROLLMENT_STATUS
where SURVEY_YEAR = '2020'
group by PF_CODE
union all
select
 SURVEY_YEAR,
 PF_CODE,
 '2' as num,
 '中学校' as KIND,
 SUM(MIDDLE) as AMT
from ENROLLMENT_STATUS
where SURVEY_YEAR = '2020'
group by PF_CODE
union all
select
 SURVEY_YEAR,
 PF_CODE,
 '3' as num,
 '高校' as KIND,
 SUM(HIGH) as AMT
from ENROLLMENT_STATUS
where SURVEY_YEAR = '2020'
group by PF_CODE
union all
select
 SURVEY_YEAR,
 PF_CODE,
 '4' as num,
 '短大' as KIND,
 SUM(JUNIOR_CLG) as AMT
from ENROLLMENT_STATUS
where SURVEY_YEAR = '2020'
group by PF_CODE
union all
select
 SURVEY_YEAR,
 PF_CODE,
 '5' as num,
 '大学' as KIND,
 SUM(COLLEGE) as AMT
from ENROLLMENT_STATUS
where SURVEY_YEAR = '2020'
group by PF_CODE
union all
select
 SURVEY_YEAR,
 PF_CODE,
 '6' as num,
 '大学院' as KIND,
 SUM(GRADUATE) as AMT
from ENROLLMENT_STATUS
where SURVEY_YEAR = '2020'
group by PF_CODE
) a
left outer join PREFECTURE b
 on a.PF_CODE = b.PF_CODE
where a.AMT is not null
order by a.PF_CODE,a.num