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