SELECT
PT.PF_CODE AS "都道府県コード",
PR.PF_NAME AS "都道府県名",
PT.TOTAL_AMT AS "総人口2015年",
PT_2020.TOTAL_AMT AS "総人口2020年",
ROUND(CAST(PT_2020.TOTAL_AMT AS REAL) / CAST(PT.TOTAL_AMT AS REAL) * 100 ) AS "人口増加率"
FROM POPU_TRANSITION PT
INNER JOIN PREFECTURE PR
ON PR.PF_CODE = PT.PF_CODE
INNER JOIN POPU_TRANSITION PT_2020
ON PT_2020.PF_CODE = PT.PF_CODE AND PT_2020.SURVEY_YEAR = 2020
WHERE PT.SURVEY_YEAR = 2015 AND PT_2020.TOTAL_AMT > PT.TOTAL_AMT
ORDER BY "人口増加率" DESC, "都道府県コード" ASC;