SELECT
    SD.PF_CODE AS CODE
    , PF.PF_NAME AS NAME
    -- 小数点第3位で四捨五入
    , ROUND( 
        ( 
            -- REAL型に変換して、小数点の計算を有効にする
            CAST(SD.PROMOTE_MUNICIPALITY AS REAL) / SD.MUNICIPALITY_TTL * 100
        ) 
        , 2
    ) AS RATIO 
FROM
    SDGS AS SD 
    INNER JOIN PREFECTURE AS PF 
        ON PF.PF_CODE = SD.PF_CODE 
WHERE
    SD.SURVEY_YEAR = 2022 
ORDER BY
    RATIO DESC
    , SD.PF_CODE ASC;