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