select
sdgs.PF_CODE CODE,
PF_NAME NAME,
round((100.0*PROMOTE_MUNICIPALITY) /MUNICIPALITY_TTL,2) RATIO

from sdgs inner join prefecture on sdgs.PF_CODE=prefecture.PF_CODE
where
survey_year=2022
order by 3 desc,1 asc
;