select 
 S.PF_CODE CODE
, P.PF_NAME NAME
, round(cast(S.PROMOTE_MUNICIPALITY as REAL)/ cast(S.MUNICIPALITY_TTL as REAL)  * 100, 2) RATIO
from SDGS S
     inner join PREFECTURE P
       on P.PF_CODE = S.PF_CODE
where S.SURVEY_YEAR = 2022
order by RATIO desc
, CODE