select SDGS.PF_CODE                                                                        CODE
     , PF_NAME                                                                             NAME
     , round(cast(PROMOTE_MUNICIPALITY as real) / cast(MUNICIPALITY_TTL as real) * 100, 2) RATIO
from SDGS
     inner join
     PREFECTURE on SDGS.PF_CODE = PREFECTURE.PF_CODE
where SURVEY_YEAR = 2022

order by 3 desc,1