SELECT 
 PREFECTURE.PF_CODE AS CODE
,PREFECTURE.PF_NAME AS NAME
,ROUND((CAST(SDGS.PROMOTE_MUNICIPALITY AS REAL) *100 / cAST(SDGS.MUNICIPALITY_TTL AS REAL)),2) 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 3 DESC,1 ASC