with t as (
  SELECT * FROM ENROLLMENT_STATUS where SURVEY_YEAR = 2020
)
, piv as (
  SELECT SURVEY_YEAR, PF_CODE, 1 as n, '小学校' as KIND, SUM(ELEMENTARY) as AMT FROM t GROUP BY SURVEY_YEAR, PF_CODE
  UNION ALL
  SELECT SURVEY_YEAR, PF_CODE, 2 as n, '中学校' as KIND, SUM(MIDDLE) as AMT FROM t GROUP BY SURVEY_YEAR, PF_CODE
  UNION ALL
  SELECT SURVEY_YEAR, PF_CODE, 3 as n, '高校' as KIND, SUM(HIGH) as AMT FROM t GROUP BY SURVEY_YEAR, PF_CODE
  UNION ALL
  SELECT SURVEY_YEAR, PF_CODE, 4 as n, '短大' as KIND, SUM(JUNIOR_CLG) as AMT FROM t GROUP BY SURVEY_YEAR, PF_CODE
  UNION ALL
  SELECT SURVEY_YEAR, PF_CODE, 5 as n, '大学' as KIND, SUM(COLLEGE) as AMT FROM t GROUP BY SURVEY_YEAR, PF_CODE
  UNION ALL
  SELECT SURVEY_YEAR, PF_CODE, 6 as n, '大学院' as KIND, SUM(GRADUATE) as AMT FROM t GROUP BY SURVEY_YEAR, PF_CODE
)
SELECT
  SURVEY_YEAR as SV_YEAR,
  PF_NAME as PREFECTURE,
  KIND,
  AMT
FROM piv
INNER JOIN PREFECTURE USING (PF_CODE)
WHERE AMT IS NOT NULL
ORDER BY PF_CODE, n