select
    SV_YEAR,
    PREFECTURE,
    AMT,
    KIND
from
(  select
    a.SURVEY_YEAR as SV_YEAR,
    b.PF_NAME as PREFECTURE,
    sum(ifnull(a.ELEMENTARY, 0)) as AMT,
    '小学校' as KIND,
    1 as NUM
  from
    ENROLLMENT_STATUS a,
    PREFECTURE b
  where
    a.PF_CODE = b.PF_CODE and
    a.SURVEY_YEAR = 2020
  group by
    SV_YEAR, PREFECTURE, KIND
union all
  select
    a.SURVEY_YEAR as SV_YEAR,
    b.PF_NAME as PREFECTURE,
    sum(ifnull(a.MIDDLE, 0)) as AMT,
    '中学校' as KIND,
    2 as NUM
  from
    ENROLLMENT_STATUS a,
    PREFECTURE b
  where
    a.PF_CODE = b.PF_CODE and
    a.SURVEY_YEAR = 2020
  group by
    SV_YEAR, PREFECTURE, KIND
union all
  select
    a.SURVEY_YEAR as SV_YEAR,
    b.PF_NAME as PREFECTURE,
    sum(ifnull(a.HIGH, 0)) as AMT,
    '高校' as KIND,
    3 as NUM
  from
    ENROLLMENT_STATUS a,
    PREFECTURE b
  where
    a.PF_CODE = b.PF_CODE and
    a.SURVEY_YEAR = 2020
  group by
    SV_YEAR, PREFECTURE, KIND
union all
  select
    a.SURVEY_YEAR as SV_YEAR,
    b.PF_NAME as PREFECTURE,
    sum(ifnull(a.JUNIOR_CLG, 0)) as AMT,
    '短大' as KIND,
    4 as NUM
  from
    ENROLLMENT_STATUS a,
    PREFECTURE b
  where
    a.PF_CODE = b.PF_CODE and
    a.SURVEY_YEAR = 2020
  group by
    SV_YEAR, PREFECTURE, KIND
union all
  select
    a.SURVEY_YEAR as SV_YEAR,
    b.PF_NAME as PREFECTURE,
    sum(ifnull(a.COLLEGE, 0)) as AMT,
    '大学' as KIND,
    5 as NUM
  from
    ENROLLMENT_STATUS a,
    PREFECTURE b
  where
    a.PF_CODE = b.PF_CODE and
    a.SURVEY_YEAR = 2020
  group by
    SV_YEAR, PREFECTURE, KIND
union all
  select
    a.SURVEY_YEAR as SV_YEAR,
    b.PF_NAME as PREFECTURE,
    sum(ifnull(a.GRADUATE, 0)) as AMT,
    '大学院' as KIND,
    6 as NUM
  from
    ENROLLMENT_STATUS a,
    PREFECTURE b
  where
    a.PF_CODE = b.PF_CODE and
    a.SURVEY_YEAR = 2020
  group by
    SV_YEAR, PREFECTURE, KIND
)
order by
  PREFECTURE asc,
  NUM asc