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