select
    p.PF_CODE as CODE,
    p.PF_NAME as NAME,
    round(cast(s.promote_municipality as real)/cast(s.municipality_ttl as real)*100, 2) as RATIO
from
    sdgs as s
inner join
    prefecture as p
on
    p.pf_code = s.pf_code
where
    survey_year == "2022"
order by
    ratio desc,
    code asc;