select SDGS.PF_CODE as CODE, PREFECTURE.PF_NAME as NAME, round(1.0 * PROMOTE_MUNICIPALITY / MUNICIPALITY_TTL * 100, 2) as RATIO
from SDGS
INNER JOIN PREFECTURE ON SDGS.PF_CODE = PREFECTURE.PF_CODE
where SURVEY_YEAR = 2022
order by RATIO desc;