with kind_master(kind_key,kind_name) as(
select 1, '小学校' union
select 2, '中学校' union
select 3, '高校'   union
select 4, '短大'   union
select 5, '大学'   union
select 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_master
group by PF_CODE,kind_key
having
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)
is not null
and 
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) > 0