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) / CAST(P1.TOTAL_AMT AS REAL)) * 100, 0) AS 人口増加率
FROM
    POPU_TRANSITION P1
LEFT OUTER JOIN
    PREFECTURE P
ON
    P1.PF_CODE = P.PF_CODE
LEFT OUTER JOIN
    POPU_TRANSITION P2
ON
    P1.PF_CODE = P2.PF_CODE
    AND
    P1.SURVEY_YEAR = '2015'
    AND
    P2.SURVEY_YEAR = '2020'
WHERE
    P1.TOTAL_AMT < P2.TOTAL_AMT
ORDER BY 
    人口増加率 DESC
;