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