SELECT
    S.PF_CODE AS CODE,
    P.PF_NAME AS NAME,
    ROUND(cast(PROMOTE_MUNICIPALITY as real) / MUNICIPALITY_TTL * 100,2) AS RATIO
FROM
    SDGS AS S
INNER JOIN
    PREFECTURE AS P
ON
    S.PF_CODE = P.PF_CODE
WHERE
    SURVEY_YEAR = 2022
ORDER BY
    RATIO DESC,
    S.PF_CODE