CREATE TEMP TABLE SC(
    RNK INTEGER
    , KIND VARCHAR(10)
);
INSERT INTO SC
VALUES (1, '小学校'), (2, '中学校'), (3, '高校'), (4, '短大'), (5, '大学'), (6, '大学院');
SELECT
SURVEY_YEAR SV_YEAR
, PF_NAME PREFECTURE
, KIND
, SUM(CASE RNK WHEN 1 THEN ELEMENTARY WHEN 2 THEN MIDDLE WHEN 3 THEN HIGH WHEN 4 THEN JUNIOR_CLG WHEN 5 THEN COLLEGE ELSE GRADUATE END) AMT
FROM ENROLLMENT_STATUS
NATURAL JOIN PREFECTURE
CROSS JOIN SC
WHERE SURVEY_YEAR = 2020
GROUP BY 1, 2, 3
HAVING AMT IS NOT NULL
ORDER BY PF_CODE, RNK