select
    PREFECTURE.PF_CODE as CODE
    ,PREFECTURE.PF_NAME as NAME
    ,SDGS2022.RAITO
from
    (select PF_CODE, ROUND(CAST(PROMOTE_MUNICIPALITY AS REAL)/CAST(MUNICIPALITY_TTL AS REAL)*100,3) 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