select 
    p.pf_code as CODE,
    p.pf_name as NAME,
    s.ratio as RATIO     
from prefecture as P
inner join
(
select 
    pf_code as CODE,
    round(cast(promote_municipality as real)/cast(municipality_ttl as real)*100,2) as ratio
from sdgs 
where survey_year=2022) as S 
on s.code=p.pf_code 
order by ratio desc,code;