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