WITH Pre_2015 AS (
SELECT
    PT.PF_CODE AS 都道府県コード,
    PR.PF_NAME AS 都道府県名,
    TOTAL_AMT  AS 総人口2015年
FROM
    POPU_TRANSITION AS PT
JOIN
    PREFECTURE AS PR
ON
    PT.PF_CODE = PR.PF_CODE
WHERE
    SURVEY_YEAR = 2015
GROUP BY
    PT.PF_CODE
),
Pre_2020 AS (
SELECT
    PT.PF_CODE AS 都道府県コード,
    PR.PF_NAME AS 都道府県名,
    TOTAL_AMT  AS 総人口2020年
FROM
    POPU_TRANSITION AS PT
JOIN
    PREFECTURE AS PR
ON
    PT.PF_CODE = PR.PF_CODE
WHERE
    SURVEY_YEAR = 2020
GROUP BY
    PT.PF_CODE
)
SELECT
    Pre_2015.都道府県コード,
    Pre_2015.都道府県名,
    Pre_2015.総人口2015年,
    Pre_2020.総人口2020年,
    ROUND( 100 * 
        ( cast(総人口2020年 AS double)  / cast(総人口2015年 AS double)  )
                ) AS 人口増加率 
FROM
    Pre_2015
JOIN
    Pre_2020
ON
    Pre_2015.都道府県コード = Pre_2020.都道府県コード
WHERE
    人口増加率 >= 100
GROUP BY
    Pre_2015.都道府県コード
ORDER BY
    人口増加率 DESC,
    Pre_2015.都道府県コード ASC