SELECT SDGS.PF_CODE AS CODE,
       PF_NAME AS NAME,
       ROUND(CAST(PROMOTE_MUNICIPALITY AS REAL) / MUNICIPALITY_TTL*100,2) AS RATIO

FROM SDGS
INNER JOIN PREFECTURE ON SDGS.PF_CODE = PREFECTURE.PF_CODE

ORDER BY RATIO DESC,SDGS.PF_CODE ASC;