SELECT 
 PREFECTURE.PF_CODE AS CODE
,PREFECTURE.PF_NAME AS NAME
,ROUND(SDGS.PROMOTE_MUNICIPALITY * 100 / SDGS.MUNICIPALITY_TTL,3) AS RATIO

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

WHERE SDGS.SURVEY_YEAR = '2022'
GROUP BY PREFECTURE.PF_CODE,PREFECTURE.PF_NAME

ORDER BY ROUND(SDGS.PROMOTE_MUNICIPALITY * 100 / SDGS.MUNICIPALITY_TTL,3)  DESC,PREFECTURE.PF_CODE ASC