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