select
    S.PF_CODE CODE
   ,P.PF_NAME NAME
   ,ROUND(100.0 * S.PROMOTE_MUNICIPALITY / S.MUNICIPALITY_TTL, 2) RATIO
from
    SDGS S
    inner join PREFECTURE P
    on  S.PF_CODE = P.PF_CODE
where
    S.SURVEY_YEAR = 2022
order by
    RATIO desc
   ,CODE