WITH NUMBER_TABLE AS
(SELECT 1 AS NO UNION ALL 
SELECT NO + 1 
FROM NUMBER_TABLE 
WHERE NO < 6) 
SELECT SV_YEAR, PREFECTURE,
CASE WHEN NO = 1 THEN '小学校'
WHEN NO = 2 THEN '中学校'
WHEN NO = 3 THEN '高校'
WHEN NO = 4 THEN '短大'
WHEN NO = 5 THEN '大学'
WHEN NO = 6 THEN '大学院'
END AS KIND,
CASE WHEN NO = 1 THEN 小学校
WHEN NO = 2 THEN 中学校
WHEN NO = 3 THEN 高校
WHEN NO = 4 THEN 短大
WHEN NO = 5 THEN 大学
WHEN NO = 6 THEN 大学院
END AS AMT
FROM (SELECT * FROM (SELECT SURVEY_YEAR AS SV_YEAR, PF_CODE, PF_NAME AS PREFECTURE,
SUM(ELEMENTARY) AS 小学校,
SUM(MIDDLE) AS 中学校,
SUM(HIGH) AS 高校,
SUM(JUNIOR_CLG) AS 短大,
SUM(COLLEGE) AS 大学,
SUM(GRADUATE) AS 大学院
FROM (SELECT * FROM
ENROLLMENT_STATUS E INNER JOIN PREFECTURE P
ON E.PF_CODE = P.PF_CODE
AND SURVEY_YEAR = 2020)
GROUP BY PREFECTURE)
CROSS JOIN NUMBER_TABLE)
WHERE AMT IS NOT NULL
ORDER BY PF_CODE