select
    s.PF_CODE as CODE
  , p.PF_NAME as NAME
  , round((s.PROMOTE_MUNICIPALITY * 100 * 1.00 / s.MUNICIPALITY_TTL * 1.00) , 3) as RATIO
from
    SDGS s
    inner join PREFECTURE p
    using(PF_CODE)
where
    s.SURVEY_YEAR = 2022
order by 
    RATIO   desc
  , PF_CODE asc
;