SELECT
SDGS.PF_CODE AS CODE
,PREFECTURE.PF_NAME AS NAME
,ROUND((CAST(PROMOTE_MUNICIPALITY AS REAL)/CAST(MUNICIPALITY_TTL AS REAL))*100,2) AS RATIO
FROM SDGS
INNER JOIN PREFECTURE
ON SDGS.PF_CODE = PREFECTURE.PF_CODE
WHERE SURVEY_YEAR = 2022
ORDER BY RATIO DESC,PREFECTURE.PF_CODE ASC;