SELECT
    p2015.PF_CODE AS 都道府県コード,
    p2015.PF_NAME AS 都道府県名,
    p2015.TOTAL_AMT AS 総人口2015年,
    p2020.TOTAL_AMT AS 総人口2020年,
    round(cast(p2020.TOTAL_AMT as REAL) / p2015.TOTAL_AMT * 100) AS 人口増加率
FROM (
    SELECT PT.PF_CODE, PRE.PF_NAME, PT.TOTAL_AMT
    FROM POPU_TRANSITION PT
    JOIN PREFECTURE PRE
    ON PT.PF_CODE = PRE.PF_CODE
    WHERE PT.SURVEY_YEAR = 2015
) AS p2015
JOIN (
    SELECT PT.PF_CODE, PT.TOTAL_AMT
    FROM POPU_TRANSITION PT
    JOIN PREFECTURE PRE
    ON PT.PF_CODE = PRE.PF_CODE
    WHERE PT.SURVEY_YEAR = 2020
) AS p2020
ON p2015.PF_CODE = p2020.PF_CODE
WHERE 人口増加率 > 100
ORDER BY 人口増加率 DESC, 都道府県コード