select p.PF_CODE as 都道府県コード, PF_NAME as 都道府県名, 
    old.TOTAL_AMT as 総人口2015年,
    new.TOTAL_AMT as 総人口2020年,
    round((new.TOTAL_AMT*1.0) / (old.TOTAL_AMT*1.0) * 100) as 人口増加率
from PREFECTURE as p
join (select TOTAL_AMT, PF_CODE from POPU_TRANSITION where SURVEY_YEAR = 2015) as old on old.PF_CODE = p.PF_CODE
join (select TOTAL_AMT, PF_CODE from POPU_TRANSITION where SURVEY_YEAR = 2020) as new on new.PF_CODE = p.PF_CODE
where 人口増加率 > 100
order by 人口増加率 desc, 都道府県コード