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