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