select 
  b.PF_CODE as CODE
 ,b.PF_NAME as NAME
 ,round(cast(a.PROMOTE_MUNICIPALITY as REAL) / cast(a.MUNICIPALITY_TTL as REAL),3) as RATIO
from   SDGS a
      ,PREFECTURE b
where
    a.SURVEY_YEAR = '2022'
and b.PF_CODE = a.PF_CODE
order by RATIO desc,b.PF_CODE