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,SDGS.PF_CODE asc;