with kind_tmp(kind_key,kind_name) as(
values(1, '小学校'),
      (2, '中学校'),
      (3, '高校'  ),
      (4, '短大'  ),
      (5, '大学'  ),
      (6, '大学院'))
select SURVEY_YEAR as SV_YEAR,
(select b.PF_NAME
   from PREFECTURE b
  where b.PF_CODE = a.PF_CODE) as PREFECTURE,
kind_name as KIND,
sum(case kind_key when 1 then ELEMENTARY
                  when 2 then MIDDLE
                  when 3 then HIGH
                  when 4 then JUNIOR_CLG
                  when 5 then COLLEGE
                  when 6 then GRADUATE end)
as AMT
  from ENROLLMENT_STATUS a join kind_tmp
 where SURVEY_YEAR = 2020
   and (kind_key = 1 and ELEMENTARY is not null
     or kind_key = 2 and MIDDLE is not null
     or kind_key = 3 and HIGH is not null
     or kind_key = 4 and JUNIOR_CLG is not null
     or kind_key = 5 and COLLEGE is not null
     or kind_key = 6 and GRADUATE is not null)
group by PF_CODE,kind_key
order by PF_CODE,kind_key