select
    P.PF_CODE as CODE,
    P.PF_NAME as NAME,
    ROUND(100.0 * S.PROMOTE_MUNICIPALITY / S.MUNICIPALITY_TTL, 2) as RATIO
from
    prefecture P
    inner join sdgs S
    on P.PF_CODE = S.PF_CODE
where
    S.SURVEY_YEAR = 2022
order by
    RATIO desc,
    P.PF_CODE
;