SELECT
S.PF_CODE AS CODE
,P.PF_NAME AS NAME
,ROUND(S.PROMOTE_MUNICIPALITY / S.MUNICIPALITY_TTL * 100,3) AS RATIO
--,S.PROMOTE_MUNICIPALITY / S.MUNICIPALITY_TTL * 100 AS RATIO
FROM
SDGS S
INNER JOIN PREFECTURE P
ON S.PF_CODE = P.PF_CODE

WHERE
S.SURVEY_YEAR = 2022

GROUP BY S.PF_CODE

ORDER BY
RATIO ASC,
S.PF_CODE ASC;