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 SDGs.PF_CODE = PREFECTURE.PF_CODE
WHERE
     SDGs.SURVEY_YEAR = 2022
ORDER BY
     cast(SDGs.PROMOTE_MUNICIPALITY as real) / cast(SDGs.MUNICIPALITY_TTL as real) DESC
     ,SDGs.PF_CODE ASC;