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