with t1 as (select case no
                       when 0 then '小学校'
                       when 1 then '中学校'
                       when 2 then '高校'
                       when 3 then '短大'
                       when 4 then '大学'
                       else '大学院'
    end KIND
                 , case no
                       when 0 then ELEMENTARY
                       when 1 then MIDDLE
                       when 2 then HIGH
                       when 3 then JUNIOR_CLG
                       when 4 then COLLEGE
                       else GRADUATE
        end AMT
                 , no
                 , SURVEY_YEAR
                 , PF_CODE
            from ENROLLMENT_STATUS
               , (WITH SEQ AS (SELECT 0 as no UNION ALL SELECT no + 1 as no FROM SEQ WHERE no + 1 < 6) select * from seq) seq

            where SURVEY_YEAR = 2020)
select SURVEY_YEAR SV_YEAR
     , PF.PF_NAME PREFECTURE
     , KIND KIND
     , sum(AMT) as AMT
from t1
     join PREFECTURE PF on PF.PF_CODE = t1.PF_CODE
where t1.amt is not null
group by SURVEY_YEAR, PF.PF_NAME, KIND, no
order by PF.PF_CODE, no