SELECT 
  TMP.SURVEY_YEAR AS SV_YEAR,
  TMP.PF_NAME AS PREFECTURE, 
  TMP.KIND_NAME AS KIND,
  SUM(TMP.AMT) AS AMT
FROM (
SELECT 
  SURVEY_YEAR,
  PF.PF_CODE, 
  PF.PF_NAME,
  KIND_CODE,
  KIND_NAME,
  AMT
FROM
  (
    SELECT SURVEY_YEAR,
    PF_CODE,
    1 AS KIND_CODE,
    '小学校' AS KIND_NAME,
    ELEMENTARY AS AMT FROM ENROLLMENT_STATUS
    UNION
    SELECT SURVEY_YEAR,
    PF_CODE,
    2 AS KIND_CODE,
    '中学校' AS KIND_NAME,
    MIDDLE AS AMT FROM ENROLLMENT_STATUS
    UNION
    SELECT SURVEY_YEAR,
    PF_CODE,
    3 AS KIND_CODE,
    '高校' AS KIND_NAME,
    HIGH AS AMT FROM ENROLLMENT_STATUS
    UNION
    SELECT SURVEY_YEAR,
    PF_CODE,
    4 AS KIND_CODE,
    '短大' AS KIND_NAME,
    JUNIOR_CLG AS AMT FROM ENROLLMENT_STATUS
    UNION
    SELECT SURVEY_YEAR,
    PF_CODE,
    5 AS KIND_CODE,
    '大学' AS KIND_NAME,
    COLLEGE AS AMT FROM ENROLLMENT_STATUS
    UNION
    SELECT SURVEY_YEAR,
    PF_CODE,
    6 AS KIND_CODE,
    '大学院' AS KIND_NAME,
    GRADUATE AS AMT FROM ENROLLMENT_STATUS
  ) TM LEFT OUTER JOIN PREFECTURE PF ON TM.PF_CODE = PF.PF_CODE
) TMP
WHERE SURVEY_YEAR = 2020
AND AMT IS NOT NULL AND AMT > 0
GROUP BY TMP.SURVEY_YEAR,
  TMP.PF_NAME, 
  TMP.KIND_NAME
ORDER BY TMP.PF_CODE, KIND_CODE