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