select 
PO2015.PF_CODE as 都道府県コード
,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),2)*100 as 人口増加率
from 
 (select * from POPU_TRANSITION where SURVEY_YEAR=2015) PO2015
, (select * from POPU_TRANSITION where SURVEY_YEAR=2020) PO2020
,PREFECTURE PR
where PR.PF_CODE=PO2015.PF_CODE and PR.PF_CODE=PO2020.PF_CODE and PO2015.PF_CODE= PO2020.PF_CODE and 人口増加率>=100
order by 人口増加率 desc,都道府県コード asc