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, CODE;