select
    p.pf_code CODE
    ,p.pf_name NAME
    ,round((s.promote_municipality*1.0 / s.municipality_ttl)*100, 2) RATIO
from
    sdgs s left join prefecture p
    on s.pf_code = p.pf_code
where
    s.survey_year = 2022
order by
    ratio desc, p.pf_code
;