select
    P.PF_CODE AS CODE
    ,P.PF_NAME AS NAME
    ,ROUND(1.0 * S.PROMOTE_MUNICIPALITY / S.MUNICIPALITY_TTL * 100, 2) AS RATIO
from
    PREFECTURE P
INNER JOIN
    SDGS S
ON
    P.PF_CODE = S.PF_CODE
order by 3 desc, 1