SELECT
SDGS.PF_CODE AS CODE,
PREFECTURE.PF_NAME AS NAME,
--PROMOTE_MUNICIPALITY,
--MUNICIPALITY_TTL,
--CAST(PROMOTE_MUNICIPALITY AS REAL) / CAST(MUNICIPALITY_TTL AS REAL) AS TMP,
ROUND((CAST(PROMOTE_MUNICIPALITY AS REAL) / CAST(MUNICIPALITY_TTL AS REAL)) * 100, 2) AS RATIO
FROM SDGS
INNER JOIN PREFECTURE
ON SDGS.PF_CODE = PREFECTURE.PF_CODE
WHERE SURVEY_YEAR = 2022
ORDER BY RATIO DESC, CODE