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