SELECT
    sd.PF_CODE AS CODE
    ,pr.PF_NAME AS NAME
    , ROUND((sd.PROMOTE_MUNICIPALITY / CAST(sd.MUNICIPALITY_TTL AS FLOAT))*100, 2) AS RATIO
FROM
    SDGS sd
LEFT OUTER JOIN PREFECTURE pr
    on sd.PF_CODE = pr.PF_CODE
WHERE
    sd.SURVEY_YEAR = 2022
ORDER BY
    RATIO DESC
    ,sd.PF_CODE;