with
    a as (
        select
            pf_code
            ,round(cast(promote_municipality as float) * 100 / cast(municipality_ttl as float), 2) as RATIO
        from
            sdgs
        where
            survey_year = 2022
    )

select
    a.pf_code as CODE
    ,p.pf_name as NAME
    ,a.RATIO
from
    a
left join
    prefecture p
on
    a.pf_code = p.pf_code
order by
    3 desc, 1