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