SELECT
ES.SURVEY_YEAR AS SV_YEAR,
PF.NAME AS PREFECTURE,
AS KIND,
AS AMT
FROM ENROLLMENT_STATUS AS ES
INNER JOIN PREFECTURE AS PF
ON ES.PF_CODE = PF.PF_CODE
INNER JOIN ENROLLMENT_STATUS AS ES_ELE
ON AND ES_ELE.SURVEY_YEAR = 2022
WHERE ES.SURVEY_YEAR = 2022
GROUP BY ES.PF_CODE
HAVING AMT IS NOT NULL
ORDER BY PF.PF_CODE ASC;