select
PR.PF_CODE as '都道府県コード'
,PR.PF_NAME as '都道府県名'
,PO1.TOTAL_AMT as '総人口2015年'
,PO2.TOTAL_AMT as '総人口2020年'
,round(cast(PO2.TOTAL_AMT as REAL)/cast(PO1.TOTAL_AMT as REAL),2)*100 as '人口増加率'
from
PREFECTURE PR
inner join
(select * from POPU_TRANSITION where SURVEY_YEAR = 2015) PO1
on PR.PF_CODE = PO1.PF_CODE

inner join
(select * from POPU_TRANSITION where SURVEY_YEAR = 2020) PO2
on PR.PF_CODE = PO2.PF_CODE

where
PO2.TOTAL_AMT > PO1.TOTAL_AMT

order by
round(cast(PO2.TOTAL_AMT as REAL)/cast(PO1.TOTAL_AMT as REAL),2)*100 desc, '都道府県コード' asc