with
    r as
    (
        select
            PF_CODE,
            round(cast(PROMOTE_MUNICIPALITY as REAL) / cast(MUNICIPALITY_TTL as REAL) * 100, 2) as RATIO
        from SDGS
        where
            SURVEY_YEAR = 2022
    )
select
    PF_CODE as CODE,
    PF_NAME as NAME,
    RATIO
from
    PREFECTURE
    join r using(PF_CODE)
ORDER BY
    RATIO desc,
    PF_CODE asc
;