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