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