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, SDGS s
where s.SURVEY_YEAR = '2022'
and p.PF_CODE = s.PF_CODE
order by RATIO desc, p.PF_CODE asc;