select pr.PF_CODE as 都道府県コード, pr.PF_NAME as 都道府県名, p2015.TOTAL_AMT as 総人口2015年, p2020.TOTAL_AMT as 総人口2020年, round(100.0*p2020.TOTAL_AMT/p2015.TOTAL_AMT) as 人口増加率
from (select p.PF_CODE, TOTAL_AMT from POPU_TRANSITION as p 
where SURVEY_YEAR = 2015) as p2015 
left outer join (select p.PF_CODE, TOTAL_AMT from POPU_TRANSITION as p 
where SURVEY_YEAR = 2020) as p2020 on p2015.PF_CODE = p2020.PF_CODE 
left outer join PREFECTURE as pr on p2015.PF_CODE = pr.PF_CODE 
where 人口増加率 > 100
order by 人口増加率 desc, 都道府県コード asc;