select
    SDGS.PF_CODE as CODE
    ,PREFECTURE.PF_NAME as NAME
    ,round(cast(PROMOTE_MUNICIPALITY as float)*100/MUNICIPALITY_TTL,2) as RATIO
from
    SDGS
    inner join PREFECTURE
    on SDGS.PF_CODE = PREFECTURE.PF_CODE
where SURVEY_YEAR = '2022'
order by
    RATIO desc
    ,CODE asc