select
    a.pf_code as CODE,
    b.pf_name as NAME,
    cast(
    cast(
    100.0 * 100.0 * cast(a.promote_municipality as numeric)
    / cast(a.municipality_ttl as numeric) 
    as integer) / 100.0 as numeric) as RATIO
from sdgs as a
inner join prefecture as b
using(pf_code)
where a.survey_year = 2022
order by 3 desc, 1;