select SDGS.PF_CODE as CODE , PF.PF_NAME as NAME , ROUND(CAST(PROMOTE_MUNICIPALITY as REAL) / MUNICIPALITY_TTL * 100 ,2) as RATIO
from SDGS
inner join PREFECTURE as PF on SDGS.PF_CODE = PF.PF_CODE
where SDGS.SURVEY_YEAR = 2022
order by RATIO desc , SDGS.PF_CODE;