select
 sdgs.pf_code as code
 , pre.pf_name as name
 , round(cast(promote_municipality as real) / municipality_ttl * 100, 2) as ratio
from sdgs
inner join prefecture pre
on pre.pf_code = sdgs.pf_code
where survey_year = 2022
order by ratio desc, sdgs.pf_code asc