WITH SDG AS (
SELECT 
    PF_CODE,
    ROUND( ( cast(PROMOTE_MUNICIPALITY as REAL) / cast(MUNICIPALITY_TTL as REAL) * 100 ) , 2) as RATIO
FROM SDGS
WHERE SURVEY_YEAR = 2022
)

Select
  PRE.PF_CODE as CODE
  , PRE.pf_name as NAME
  , RATIO
FROM
    PREFECTURE as PRE join SDG on PRE.PF_CODE = SDG.PF_CODE
ORDER BY
    RATIO desc
    , PRE.PF_CODE