SELECT
PR.PF_CODE AS 都道府県コード,
PR.PF_NAME AS 都道府県名,
PO1.TOTAL_AMT AS 総人口2015年,
PO2.TOTAL_AMT AS 総人口2020年
,ROUND(CAST(PO2.TOTAL_AMT as real) / CAST(PO1.TOTAL_AMT as real) * 100) AS 人口増加率
FROM PREFECTURE PR
INNER JOIN (SELECT PF_CODE,SURVEY_YEAR,TOTAL_AMT FROM POPU_TRANSITION WHERE SURVEY_YEAR='2015') PO1
ON PR.PF_CODE = PO1.PF_CODE
INNER JOIN (SELECT PF_CODE,SURVEY_YEAR,TOTAL_AMT FROM POPU_TRANSITION WHERE SURVEY_YEAR='2020') PO2
ON PR.PF_CODE = PO2.PF_CODE
WHERE PO1.TOTAL_AMT < PO2.TOTAL_AMT
order by 人口増加率 desc, PR.PF_CODE