select
PR.PF_CODE as 都道府県コード
,PF_NAME as 都道府県名
,HO2015.TOTAL_AMT as 総人口2015年
,HO2020.TOTAL_AMT as 総人口2020年
,round(cast(HO2020.TOTAL_AMT as real)*100/cast(HO2015.TOTAL_AMT as real),0) as 人口増加率
from
(select * from POPU_TRANSITION where SURVEY_YEAR=2015) HO2015
,(select * from POPU_TRANSITION where SURVEY_YEAR=2020) HO2020
,PREFECTURE PR
where
HO2020.PF_CODE=HO2015.PF_CODE and
HO2020.PF_CODE=PR.PF_CODE and
人口増加率>=100
order by 人口増加率 desc,都道府県コード asc