with seq as (
    select 1 as seq_no
    union all
    select seq_no + 1
    from seq
    where seq_no < 6
)
select
    tmp.survey_year SV_YEAR, 
    p.pf_name PREFECTURE,
    tmp.kind KIND,
    sum(tmp.amt) AMT
from 
(
    select
        e.survey_year,
        e.pf_code,
        s.seq_no,
        case seq_no
            when 1 then '小学校'
            when 2 then '中学校'
            when 3 then '高校'
            when 4 then '短大'
            when 5 then '大学'
            when 6 then '大学院'
            else null
        end kind,
        case seq_no
            when 1 then e.elementary
            when 2 then e.middle
            when 3 then e.high
            when 4 then e.junior_clg
            when 5 then e.college
            when 6 then e.graduate
            else null
        end amt
    from ENROLLMENT_STATUS e
    cross join seq s
    where e.survey_year = '2020'
)tmp
join PREFECTURE p on tmp.pf_code = p.pf_code
where 1 = 1
and tmp.amt is not null
group by tmp.survey_year, p.pf_name, tmp.kind
order by tmp.pf_code asc, tmp.seq_no asc
;