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;