select pref.PF_CODE as CODE
     , pref.PF_NAME as NAME
     , (select round(cast(sd.PROMOTE_MUNICIPALITY as real) / cast(sd.MUNICIPALITY_TTL as real) * 100  , 2)
          from SDGS sd
         where sd.PF_CODE = pref.PF_CODE
           and sd.SURVEY_YEAR = 2022
       ) as RATIO
  from PREFECTURE pref
 order by RATIO desc, pref.PF_CODE asc