select
    PF_CODE as CODE,
    PF_NAME as NAME,
    ROUND(CAST(PROMOTE_MUNICIPALITY as float) / MUNICIPALITY_TTL * 100, 2) as RATIO
from 
    PREFECTURE
    join SDGS using (PF_CODE)
where
    SURVEY_YEAR = 2022
order by
    RATIO desc,
    PF_CODE;