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