SELECT
S.PF_CODE AS CODE
,P.PF_NAME AS NAME
--計算して求めた割合
,ROUND((S.PROMOTE_MUNICIPALITY / S.MUNICIPALITY_TTL) * 100,3) AS RATIO
-- 四捨五入してROUND(X, Y)
FROM
SDGS S
INNER JOIN PREFECTURE P
ON S.PF_CODE = P.PF_CODE

WHERE
S.SURVEY_YEAR = 2022

ORDER BY
S.RATIO ASC,
S.PF_CODE ASC;