select
 SURVEY_YEAR as SV_YEAR
,PREFECTURE.PF_NAME as PREFECTURE
,KIND
,amount as AMT
from(

select
 SURVEY_YEAR
,PF_CODE
,'小学校' as KIND
,sum(ELEMENTARY) as amount
,1 as disp
from ENROLLMENT_STATUS
where
 SURVEY_YEAR = 2020
group by 
 SURVEY_YEAR
,PF_CODE

union all

select
 SURVEY_YEAR
,PF_CODE
,'中学校' as KIND
,sum(MIDDLE) as amount
,2 as disp
from ENROLLMENT_STATUS
where
 SURVEY_YEAR = 2020
group by 
 SURVEY_YEAR
,PF_CODE

union all

select
 SURVEY_YEAR
,PF_CODE
,'高校' as KIND
,sum(HIGH) as amount
,3 as disp
from ENROLLMENT_STATUS
where
 SURVEY_YEAR = 2020
group by 
 SURVEY_YEAR
,PF_CODE

union all

select
 SURVEY_YEAR
,PF_CODE
,'短大' as KIND
,sum(JUNIOR_CLG) as amount
,4 as disp
from ENROLLMENT_STATUS
where
 SURVEY_YEAR = 2020
group by 
 SURVEY_YEAR
,PF_CODE

union all

select
 SURVEY_YEAR
,PF_CODE
,'大学' as KIND
,sum(COLLEGE) as amount
,5 as disp
from ENROLLMENT_STATUS
where
 SURVEY_YEAR = 2020
group by 
 SURVEY_YEAR
,PF_CODE

union all

select
 SURVEY_YEAR
,PF_CODE
,'大学院' as KIND
,sum(GRADUATE) as amount
,6 as disp
from ENROLLMENT_STATUS
where
 SURVEY_YEAR = 2020
group by 
 SURVEY_YEAR
,PF_CODE

)as main
inner join
 PREFECTURE
 on main.PF_CODE = PREFECTURE.PF_CODE
where amount is not null
order by
 main.PF_CODE
,main.disp