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