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