select 
sdgs.pf_code as code
, prefecture.pf_name as NAME
, round((100.0 * promote_municipality / municipality_ttl), 2) as ratio
from sdgs join prefecture on sdgs.pf_code = prefecture.pf_code
where survey_year = 2022
order by ratio desc, sdgs.pf_code