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