SELECT
    P15.PF_CODE AS '都道府県コード',
    PF.PF_NAME AS '都道府県名',
    P15.TOTAL_AMT AS '総人口2015年',
    P20.TOTAL_AMT AS '総人口2020年',
    ROUND(CAST(P20.TOTAL_AMT AS REAL)/CAST(P15.TOTAL_AMT AS REAL)*100) AS '人口増加率'
FROM
    POPU_TRANSITION AS P15
    INNER JOIN PREFECTURE AS PF ON P15.PF_CODE=PF.PF_CODE
    INNER JOIN (
        SELECT PF_CODE, TOTAL_AMT
        FROM POPU_TRANSITION
        WHERE SURVEY_YEAR=2020
        ) AS P20
    ON P15.PF_CODE=P20.PF_CODE
WHERE
    SURVEY_YEAR=2015
    AND P15.TOTAL_AMT < P20.TOTAL_AMT
ORDER BY
    人口増加率 DESC,
    都道府県コード
;