SELECT
    SDGS.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 AS PF
        ON PF.PF_CODE=SDGS.PF_CODE
WHERE
    SURVEY_YEAR=2022
ORDER BY
    RATIO DESC,
    CODE ASC
    ;