select PREFECTURE.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 PREFECTURE inner join SDGS on PREFECTURE.PF_CODE = SDGS.PF_CODE
where SDGS.SURVEY_YEAR = 2022
order by RATIO desc,
         CODE asc;