WITH TMP_2020_TABLE AS(
    SELECT 
        PF_CODE,
        TOTAL_AMT AS TOTAL_2020_AMT
    FROM 
        POPU_TRANSITION 
    WHERE
        SURVEY_YEAR = 2020
)
SELECT
    POPU_TRANSITION.PF_CODE AS 都道府県コード,
    PF_NAME AS 都道府県名,
    TOTAL_AMT AS 総人口2015年,
    TOTAL_2020_AMT AS 総人口2020年,
    ROUND(CAST(TOTAL_2020_AMT*100 AS FLOAT) / CAST(TOTAL_AMT AS FLOAT), 0) AS 人口増加率
FROM
    POPU_TRANSITION
INNER JOIN 
    TMP_2020_TABLE
ON 
    TMP_2020_TABLE.PF_CODE = POPU_TRANSITION.PF_CODE
INNER JOIN 
    PREFECTURE
ON 
    PREFECTURE.PF_CODE = POPU_TRANSITION.PF_CODE
WHERE
    (SURVEY_YEAR = 2015) AND (総人口2015年 < 総人口2020年)
ORDER BY
    人口増加率 DESC,
    都道府県コード ASC