select
 PO.PF_CODE as 都道府県コード
,PRE.PF_NAME as 都道府県名
,PO2015.TOTAL_AMT as 総人口2015年
,PO2020.TOTAL_AMT as 総人口2020年
,ROUND(CAST(PO2020.TOTAL_AMT as REAL) / CAST(PO2015.TOTAL_AMT as REAL) * 100 ,0) as 人口増加率
from ((select * from POPU_TRANSITION where SURVEY_YEAR = 2015) as PO2015

inner join (select * from POPU_TRANSITION where SURVEY_YEAR = 2020) as PO2020
on PO2015.PF_CODE = PO2020.PF_CODE
) as PO

inner join PREFECTURE as PRE
on PO.PF_CODE = PRE.PF_CODE

where
PO2015.TOTAL_AMT <= PO2020.TOTAL_AMT

order by
 ROUND(CAST(PO2020.TOTAL_AMT as REAL) / CAST(PO2015.TOTAL_AMT as REAL) * 100 ,0) desc
,PO.PF_CODE asc