SELECT
 p.PF_CODE as CODE,
 p.PF_NAME as NAME,
 round(cast(s.PROMOTE_MUNICIPALITY as REAL) / cast(s.MUNICIPALITY_TTL as REAL) * 100, 2) as RATIO
FROM
 PREFECTURE p
INNER JOIN
 SDGS s
ON
 p.PF_CODE = s.PF_CODE
WHERE
 SURVEY_YEAR = 2022
ORDER BY
 RATIO DESC,
 CODE ASC;