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