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