SELECT
 PF_CODE AS 都道府県コード
 ,S.PF_NAME AS 都道府県名
 ,S.TOTAL_AMT2015 AS 総人口2015年
 ,S.TOTAL_AMT2020 AS 総人口2020年
 ,S.INC_RATE AS 人口増加率
FROM
(
    SELECT
        P.PF_CODE
        ,P.PF_NAME
        ,S2015.TOTAL_AMT AS TOTAL_AMT2015
        ,S2020.TOTAL_AMT AS TOTAL_AMT2020
        ,ROUND(CAST(S2020.TOTAL_AMT AS REAL) / CAST(S2015.TOTAL_AMT AS REAL) * 100, 0) AS INC_RATE
    FROM PREFECTURE P
    INNER JOIN
    (
        SELECT
            PF_CODE
            ,TOTAL_AMT
        FROM POPU_TRANSITION
        WHERE SURVEY_YEAR = 2015
    ) S2015
    ON S2015.PF_CODE = P.PF_CODE
    INNER JOIN
    (
        SELECT
            PF_CODE
            ,TOTAL_AMT
        FROM POPU_TRANSITION
        WHERE SURVEY_YEAR = 2020
    ) S2020
    ON S2020.PF_CODE = P.PF_CODE
) S
WHERE S.INC_RATE > 100
ORDER BY S.INC_RATE DESC, S.PF_CODE ASC