with SEQ_TBL as ( 
    select 1 as SEQ_NO, '小学校' as SEQ_KIND
    union all 
    select 2, '中学校'
    union all 
    select 3, '高校'
    union all 
    select 4, '短大'
    union all 
    select 5, '大学'
    union all 
    select 6, '大学院'
) 
select 
    es.SURVEY_YEAR SV_YEAR,
    p.PF_NAME PREFECTURE,
    st.SEQ_KIND 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