SELECT
	SD.PF_CODE AS CODE,
	PR.PF_NAME AS NAME,
    ROUND( 
        -- 計算項目がINTEGER型なのでCAST関数でREAL型に変換して計算しています
        CAST(SD.PROMOTE_MUNICIPALITY AS REAL) /
        CAST(SD.MUNICIPALITY_TTL AS REAL ) * 100
        , 2
    ) AS RATIO 

  
FROM
    SDGS AS SD 
    INNER JOIN PREFECTURE AS PR 
        ON SD.PF_CODE = PR.PF_CODE 
WHERE
    SD.SURVEY_YEAR  = 2022         		
        		
        		
ORDER BY
    RATIO  DESC
    , SD.PF_CODE ASC;