SELECT
    t1.PF_CODE as CODE
    ,PF_NAME as NAME
    ,round(cast(PROMOTE_MUNICIPALITY as real)/ MUNICIPALITY_TTL *100,2) as RATIO
    --計算して求めた割合 → RATIO
FROM
    SDGS t1
inner join PREFECTURE t2 on t1.PF_CODE = t2.PF_CODE
WHERE
    SURVEY_YEAR = '2022'
order by RATIO desc