select pr.PF_CODE as 都道府県コード, pr.PF_NAME as 都道府県名, p1.TOTAL_AMT as 総人口2015年,p2.TOTAL_AMT as 総人口2020年, round( 100 * (cast(p2.TOTAL_AMT as REAL) / p1.TOTAL_AMT))as 人口増加率
from 
(select * from POPU_TRANSITION where SURVEY_YEAR = 2015) as p1
left outer join
(select * from POPU_TRANSITION where SURVEY_YEAR = 2020) as p2
on p2.PF_CODE = p1.PF_CODE
left outer join
PREFECTURE as pr
on p2.PF_CODE = pr.PF_CODE
order by 人口増加率 DESC, 都道府県コード ASC
;