SELECT 
p.PF_CODE AS "都道府県コード",
p.PF_NAME AS "都道府県名",
pt1.TOTAL_AMT AS "総人口2015年",
pt2.TOTAL_AMT AS "総人口2020年",
round((cast(pt2.TOTAL_AMT-pt1.TOTAL_AMT AS real)/cast(pt1.TOTAL_AMT as real))*100,0) + 100 AS "人口増加率"
FROM PREFECTURE AS p
INNER JOIN POPU_TRANSITION AS pt1 ON p.PF_CODE = pt1.PF_CODE
INNER JOIN POPU_TRANSITION AS pt2 ON p.PF_CODE = pt2.PF_CODE
WHERE pt1.SURVEY_YEAR = 2015
AND pt2.SURVEY_YEAR = 2020
ORDER BY "人口増加率" DESC, "都道府県コード" ASC;