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
;