SELECT A.PF_CODE AS CODE 
      ,A.PF_NAME NAME
      ,ROUND( (B.PROMOTE_MUNICIPALITY / B.MUNICIPALITY_TTL) * 100 ,3) AS RATIO
FROM PREFECTURE A 
INNER JOIN SDGS B 
   ON A.PF_CODE = B.PF_CODE
  AND B.SURVEY_YEAR = 2022
ORDER BY ROUND( (B.PROMOTE_MUNICIPALITY / B.MUNICIPALITY_TTL) * 100 ,3) DESC
        ,A.PF_CODE;