select
	PT.PF_CODE AS 都道府県コード
	,PR.PF_NAME AS 都道府県名
	,PT.TOTAL_AMT AS 総人口2015年
	,PT2020.TOTAL_AMT AS 総人口2020年
	,ROUND(CAST(PT2020.TOTAL_AMT AS REAL)/CAST(PT.TOTAL_AMT AS REAL) * 100) AS 人口増加率
from
	POPU_TRANSITION AS PT
inner join
	PREFECTURE PR
on
	PT.PF_CODE = PR.PF_CODE
inner join
    (select
        *
    from
        POPU_TRANSITION AS PT
    where
        SURVEY_YEAR = 2020) AS PT2020
on
    PT2020.PF_CODE = PR.PF_CODE
where
	PT.SURVEY_YEAR = 2015
group by
	PT.PF_CODE
	,PR.PF_NAME
order by
    人口増加率 DESC
    ,都道府県コード ASC