select SURVEY_YEAR as SV_YEAR, PF_NAME as PREFECTURE, KIND,AMT
from 
(
select SURVEY_YEAR , PF_CODE, "小学校" as KIND, sum(ELEMENTARY) as AMT, 0 as dummy  from ENROLLMENT_STATUS where ELEMENTARY is not null group by PF_CODE,SURVEY_YEAR
union all
select SURVEY_YEAR , PF_CODE,"中学校" as KIND, sum(MIDDLE) as AMT, 1 as dummy  from ENROLLMENT_STATUS where MIDDLE is not null group by PF_CODE,SURVEY_YEAR
union all
select SURVEY_YEAR , PF_CODE, "高校" as KIND, sum(HIGH) as AMT, 2 as dummy  from ENROLLMENT_STATUS where HIGH is not null group by PF_CODE,SURVEY_YEAR
union all
select SURVEY_YEAR , PF_CODE, "短大" as KIND, sum(JUNIOR_CLG) as AMT, 3 as dummy  from ENROLLMENT_STATUS where JUNIOR_CLG is not null group by PF_CODE,SURVEY_YEAR
union all
select SURVEY_YEAR , PF_CODE, "大学" as KIND, sum(COLLEGE) as AMT, 4 as dummy  from ENROLLMENT_STATUS where COLLEGE is not null group by PF_CODE,SURVEY_YEAR
union all
select SURVEY_YEAR , PF_CODE, "大学院" as KIND, sum(GRADUATE) as AMT, 5 as dummy  from ENROLLMENT_STATUS where GRADUATE is not null group by PF_CODE,SURVEY_YEAR
)
left join PREFECTURE using (PF_CODE)
where SV_YEAR = 2020
order by PF_CODE, dummy

-- select SURVEY_YEAR , PF_CODE, "小学校" as KIND, sum(ELEMENTARY) as AMT, 0 as dummy  from ENROLLMENT_STATUS where ELEMENTARY is not null group by PF_CODE