SELECT
    PF.PF_CODE AS '都道府県コード',
    PF.PF_NAME AS '都道府県名',
    TOTAL_AMT_2015 AS '総人口2015年',
    TOTAL_AMT_2020 AS '総人口2020年',
    ROUND(CAST(TOTAL_AMT_2020 AS FLOAT)/CAST(TOTAL_AMT_2015 AS FLOAT)*100) AS '人口増加率'
FROM
    (SELECT
        PP_2015.PF_CODE,
        TOTAL_AMT_2015,
        TOTAL_AMT_2020
    FROM
    (
    SELECT
        PF_CODE,
        TOTAL_AMT AS TOTAL_AMT_2015
    FROM 
        POPU_TRANSITION
    WHERE
        SURVEY_YEAR = 2015
    ) AS PP_2015
    JOIN
    (
    SELECT
        PF_CODE,
        TOTAL_AMT AS TOTAL_AMT_2020
    FROM 
        POPU_TRANSITION
    
    WHERE
        SURVEY_YEAR = 2020
    ) AS PP_2020
    ON 
        PP_2015.PF_CODE = PP_2020.PF_CODE)
    AS PP
JOIN
    PREFECTURE AS PF
ON
    PF.PF_CODE = PP.PF_CODE
WHERE
    TOTAL_AMT_2015 < TOTAL_AMT_2020
ORDER BY
    人口増加率 DESC,
    PF.PF_CODE ASC