select 
PF_CODE as CODE
,PF_NAME as NAME
, round(CAST(PROMOTE_MUNICIPALITY as float)/MUNICIPALITY_TTL,3)*100 as RATIO
from PREFECTURE
inner join SDGS using (PF_CODE)
where SURVEY_YEAR = 2022
order by 
RATIO desc
, PF_CODE