SELECT 
 T1.PF_CODE CODE
,T2.PF_NAME NAME
,ROUND((T1.PROMOTE_MUNICIPALITY*1.0) / (T1.MUNICIPALITY_TTL*1.0) *100,2) RATIO
FROM SDGS T1
LEFT OUTER JOIN PREFECTURE T2
  ON T1.PF_CODE = T2.PF_CODE
WHERE SURVEY_YEAR = '2022'
ORDER BY 
 RATIO DESC
,CODE