with SEQ_TBL as ( 
    select
        1 as SEQ_NO 
    union all 
    select
        SEQ_NO + 1 
    from
        SEQ_TBL 
    where
        SEQ_NO < 6
) 
select 
    es.SURVEY_YEAR SV_YEAR,
    p.PF_NAME PREFECTURE,
    case st.SEQ_NO 
        when 1 then '小学校'
        when 2 then '中学校'
        when 3 then '高校'
        when 4 then '短大'
        when 5 then '大学'
        when 6 then '大学院'
    end KIND,
    case st.SEQ_NO 
        when 1 then sum(ELEMENTARY)
        when 2 then sum(MIDDLE)
        when 3 then sum(HIGH)
        when 4 then sum(JUNIOR_CLG)
        when 5 then sum(COLLEGE)
        when 6 then sum(GRADUATE)
    end AMT
from ENROLLMENT_STATUS es
    cross join SEQ_TBL st
    left outer join PREFECTURE p on es.PF_CODE = p.PF_CODE
group by es.SURVEY_YEAR, es.PF_CODE, st.SEQ_NO
having es.SURVEY_YEAR = 2020
    and AMT is not null
order by es.PF_CODE, st.SEQ_NO