SELECT 
    SDG.PF_CODE AS CODE
    ,PRE.PF_NAME AS NAME
    ,ROUND((CAST(SDG.PROMOTE_MUNICIPALITY AS REAL) / CAST(SDG.MUNICIPALITY_TTL AS REAL) * 100),2) AS RATIO
FROM PREFECTURE PRE

INNER JOIN SDGS SDG
    ON PRE.PF_CODE = SDG.PF_CODE AND SDG.SURVEY_YEAR = '2022'
ORDER BY 
    RATIO DESC
    ,SDG.PF_CODE DESC;