select
  main.PF_CODE as CODE
 ,pre.PF_NAME as NAME
 ,round(PROMOTE_MUNICIPALITY * 100.0 / MUNICIPALITY_TTL, 2) as RATIO
from
    SDGS as main
inner join
    PREFECTURE as pre using(PF_CODE)
where
    main.SURVEY_YEAR = 2022
order by
     RATIO desc
    ,PF_CODE asc