SELECT
T2.PF_CODE AS CODE
,t2.PF_NAME AS NAME
,round(cast(PROMOTE_MUNICIPALITY AS real)/cast(MUNICIPALITY_TTL AS real)*100,2) AS RATIO
FROM
 SDGS AS t1
,PREFECTURE AS T2
WHERE
t1.PF_CODE = t2.PF_CODE
AND t1.SURVEY_YEAR = 2022
ORDER BY round(cast(PROMOTE_MUNICIPALITY AS real)/cast(MUNICIPALITY_TTL AS real)*100,2) DESC
,T2.PF_CODE