SELECT
    t1.PF_CODE as CODE
    ,PF_NAME as NAME
    ,round(cast(PROMOTE_MUNICIPALITY as real)/ cast(MUNICIPALITY_TTL as real) *100,2) as RATIO
FROM
    SDGS t1
inner join PREFECTURE t2 on t1.PF_CODE = t2.PF_CODE
WHERE
    SURVEY_YEAR = '2022'
order by RATIO desc