WITH TBL AS
(SELECT 1 AS NO UNION ALL SELECT 1 + NO FROM TBL WHERE NO < 6)

,KIND_TBL AS
(SELECT
NO,
CASE NO
WHEN 1 THEN "小学校"
WHEN 2 THEN "中学校"
WHEN 3 THEN "高校"
WHEN 4 THEN "短大"
WHEN 5 THEN "大学"
WHEN 6 THEN "大学院"
END AS KIND
FROM TBL)

SELECT
SURVEY_YEAR AS SV_YEAR,
PF_NAME AS PREFECTURE,
KIND,
CASE KIND
WHEN "小学校" THEN SUM(ELEMENTARY)
WHEN "中学校" THEN SUM(MIDDLE)
WHEN "高校" THEN SUM(HIGH)
WHEN "短大" THEN SUM(JUNIOR_CLG)
WHEN "大学" THEN SUM(COLLEGE)
WHEN "大学院" THEN SUM(GRADUATE)
END AS AMT
FROM ENROLLMENT_STATUS
CROSS JOIN KIND_TBL
JOIN PREFECTURE
USING(PF_CODE)
WHERE SURVEY_YEAR = 2020
GROUP BY SURVEY_YEAR,PF_CODE,KIND
HAVING AMT IS NOT NULL
ORDER BY PF_CODE,NO