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