select A.PF_CODE as '都道府県コード', A.PF_NAME as '都道府県名', B.TOTAL_AMT as '総人口2015年', C.TOTAL_AMT as '総人口2020年', round(cast(C.TOTAL_AMT as REAL) / cast(B.TOTAL_AMT as REAL) * 100, 0) as '人口増加率'  from PREFECTURE A
join POPU_TRANSITION B
on A.PF_CODE=B.PF_CODE
and B.SURVEY_YEAR=2015
join POPU_TRANSITION C
on A.PF_CODE=C.PF_CODE
and C.SURVEY_YEAR=2020
where C.TOTAL_AMT/B.TOTAL_AMT >= 1
order by 5 desc, A.PF_CODE asc

;