select SDGS.PF_CODE as CODE,
    PREFECTURE.PF_NAME as NAME,
    (SDGS.PROMOTE_MUNICIPALITY/SDGS.MUNICIPALITY_TTL) as RATIO
    from SDGS
    join PREFECTURE
    on SDGS.PF_CODE = PREFECTURE.PF_CODE
    where SDGS.SURVEY_YEAR = 2022
    order by RATIO DESC, SDGS.PF_CODE;