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