select
    PREFECTURE.PF_CODE as CODE
    ,PREFECTURE.PF_NAME as NAME
    ,SDGS2022.RAITO
from
    (select PF_CODE, PROMOTE_MUNICIPALITY*100/MUNICIPALITY_TTL as RAITO
    from SDGS
    where SURVEY_YEAR=2022
    ) SDGS2022
inner join
    PREFECTURE
on SDGS2022.PF_CODE=PREFECTURE.PF_CODE
order by
    SDGS2022.RAITO desc
    ,PREFECTURE.PF_CODE asc