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