select
 sdgs.pf_code as code
 , pre.pf_name as name
 , round(100.00 * promote_municipality / municipality_ttl, 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