SELECT
a.PF_CODE AS "都道府県コード",
PF_NAME AS "都道府県名",
TOTAL_AMT_2015 AS "総人口2015年",
TOTAL_AMT AS "総人口2020年",
CAST(ROUND(CAST(TOTAL_AMT AS REAL) / TOTAL_AMT_2015 * 100) 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
AND "人口増加率" >= CAST(100 AS INTEGER)
ORDER BY "人口増加率" DESC, "都道府県コード" ASC