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