select 
  b.pf_code as CODE 
  ,b.pf_name as NAME 
  ,round(100 * (cast(promote_municipality as real) / municipality_ttl), 2) as RATIO
from sdgs a
inner join prefecture b 
  on a.pf_code = b.pf_code 
where survey_year = 2022

order by RATIO desc, b.PF_CODE

;