SELECT SURVEY_YEAR AS SV_YEAR
,PF_NAME AS PREFECTURE
,集計した就学先の種類 AS KIND
,就学先ごとに集計した人数 AS AMT
FROM ENROLLMENT_STATUS AS ES
LEFT JOIN PREFECTURE AS PR
ON ES.PF_CODE = PR.PF_CODE 
INNER JOIN (SELECT SUM(CASE WHEN ELEMENTARY='1000' THEN AGE ELSE 0 END ))
ON
WHERE SURVEY_YEAR='2020'
AND AMT IS NOT NULL
GROUP BY
ORDER BY 都道府県コードの昇順
就学状況データの就学先を左から並べた順番（小学校→・・→大学院）