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