select
P.PF_CODE as 都道府県コード
, P.PF_NAME as 都道府県名
, P_2015.TOTAL_AMT as 総人口2015年
, P_2020.TOTAL_AMT as 総人口2020年
, ROUND(CAST(P_2020.TOTAL_AMT as REAL) * 100 / CAST(P_2015.TOTAL_AMT as REAL)) as 人口増加率
from PREFECTURE as P
join (select * from POPU_TRANSITION where SURVEY_YEAR = '2015') as P_2015 on P_2015.PF_CODE = P.PF_CODE
join (select * from POPU_TRANSITION where SURVEY_YEAR = '2020') as P_2020 on P_2020.PF_CODE = P.PF_CODE
where CAST(P_2020.TOTAL_AMT as REAL) * 100 / CAST(P_2015.TOTAL_AMT as REAL) >= 100
order by 人口増加率 desc, 都道府県コード asc