SELECT
a.PF_CODE AS "都道府県コード",
PF_NAME AS "都道府県名",
TOTAL_AMT_2015 AS "総人口2015年",
TOTAL_AMT AS "総人口2020年",
CAST(CAST((TOTAL_AMT - TOTAL_AMT_2015) AS REAL) / TOTAL_AMT_2015 * 100 + 100.5 AS INTEGER) AS "人口増加率"
FROM POPU_TRANSITION a
LEFT JOIN (
SELECT PF_CODE, TOTAL_AMT AS TOTAL_AMT_2015 FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2015
) b
ON a.PF_CODE = b.PF_CODE
LEFT JOIN PREFECTURE p
ON a.PF_CODE = p.PF_CODE
WHERE SURVEY_YEAR = 2020
ORDER BY "人口増加率" DESC, "都道府県コード" ASC