select s.pf_code as CODE,p.pf_name as NAME, round(cast(s.PROMOTE_MUNICIPALITY as float)/s.MUNICIPALITY_TTL*100,3) RATIO
from sdgs s
left join prefecture p on s.pf_code= p.pf_code
where survey_year = 2022
order by CODE asc, RATIO desc;