SELECT
    s.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 s
    INNER JOIN PREFECTURE p ON p.PF_CODE = s.PF_CODE
WHERE
    SURVEY_YEAR = 2022
ORDER BY
    RATIO DESC,
    s.PF_CODE