SELECT
2020 SV_YEAR,
P.PF_NAME PREFECTURE,
K.KIND KIND,
CASE
  WHEN K.KIND = "小学校" THEN D.ELEMENTARY
  WHEN K.KIND = "中学校" THEN D.MIDDLE
  WHEN K.KIND = "高校" THEN D.HIGH
  WHEN K.KIND = "短大" THEN D.JUNIOR_CLG
  WHEN K.KIND = "大学" THEN D.COLLEGE
  WHEN K.KIND = "大学院" THEN D.GRADUATE
  ELSE NULL
END AMT
FROM
(SELECT PF_CODE,
SUM(ELEMENTARY) ELEMENTARY,
SUM(MIDDLE) MIDDLE,
SUM(HIGH) HIGH,
SUM(JUNIOR_CLG) JUNIOR_CLG,
SUM(COLLEGE) COLLEGE,
SUM(GRADUATE) GRADUATE
FROM ENROLLMENT_STATUS
WHERE SURVEY_YEAR = 2020
GROUP BY SURVEY_YEAR, PF_CODE
ORDER BY PF_CODE ASC) D
CROSS JOIN
(SELECT "" KIND
UNION
VALUES
("小学校"),
("中学校"),
("高校"),
("短大"),
("大学"),
("大学院")) K
INNER JOIN PREFECTURE P ON D.PF_CODE = P.PF_CODE
WHERE AMT IS NOT NULL AND AMT > 0
ORDER BY PREFECTURE ASC,
CASE KIND
  WHEN "小学校" THEN 0
  WHEN "中学校" THEN 1
  WHEN "高校" THEN 2
  WHEN "短大" THEN 3
  WHEN "大学" THEN 4
  WHEN "大学院" THEN 5
END