SELECT
 p.PF_CODE as CODE,
 p.PF_NAME as NAME,
 ROUND(s.PROMOTE_MUNICIPALITY / s.MUNICIPALITY_TTL * 100, 3) as RATIO
FROM
 PREFECTURE p
INNER JOIN
 SDGS s
ON
 p.PF_CODE = s.PF_CODE
WHERE
 SURVEY_YEAR = 2022
ORDER BY
 RATIO,
 CODE;