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
 where exists (select 'dummy'
                 from SDGS sd
                where pref.PF_CODE = sd.PF_CODE
                  and sd.SURVEY_YEAR = 2022)
 order by RATIO desc, pref.PF_CODE asc