select
    PR.PF_CODE as CODE
    ,PR.PF_NAME as NAME
    ,ROUND(cast(SDGS.PROMOTE_MUNICIPALITY as REAL)/cast(SDGS.MUNICIPALITY_TTL as REAL) * 100,2) as RATIO
from
    PREFECTURE as PR
    inner join SDGS
    on PR.PF_CODE = SDGS.PF_CODE
where
    SDGS.SURVEY_YEAR = 2022
order by 
    RATIO desc,PR.PF_CODE;