select
    a.pf_code as CODE,
    b.pf_name as NAME,
    round(100.0 * cast(a.promote_municipality as real) / cast(a.municipality_ttl as real), 2) as RATIO
from sdgs as a
inner join prefecture as b
using(pf_code)
where a.survey_year = 2022
order by 3 desc, 1;