SELECT
    "都道府県コード"
    ,"都道府県名"
    ,TABLE2015.TOTAL_AMT as "総人口2015年"
    ,TABLE2020.TOTAL_AMT as "総人口2020年"
    ,ROUND(
        CAST(TABLE2020.TOTAL_AMT AS FLOAT) / TABLE2015.TOTAL_AMT * 100
    )
    as "人口増加率"
    -- ,人口増加率を%で表示(小数点以下は四捨五入) as "人口増加率"
FROM (
    SELECT
        p.PF_CODE as "都道府県コード"
        ,PF_NAME as "都道府県名"
    	,SURVEY_YEAR as "調査年"
    	,TOTAL_AMT as "総人口"
    	,TOTAL_AMT - LAG(TOTAL_AMT) 
    	    OVER (PARTITION BY p.PF_CODE ORDER BY SURVEY_YEAR)
    	    as "_2015年から2020年の総人口増加数"
    FROM
        POPU_TRANSITION
    INNER JOIN
        PREFECTURE p ON POPU_TRANSITION.PF_CODE = p.PF_CODE
    WHERE
        SURVEY_YEAR in (2015, 2020)
) as pt
LEFT JOIN
    (
    SELECT
        *
    FROM
        POPU_TRANSITION
    WHERE
        SURVEY_YEAR = 2020
    ) as TABLE2020
    ON pt."都道府県コード" = TABLE2020.PF_CODE
LEFT JOIN
    (
    SELECT
        *
    FROM
        POPU_TRANSITION
    WHERE
        SURVEY_YEAR = 2015
    ) as TABLE2015
    ON pt."都道府県コード" = TABLE2015.PF_CODE
WHERE
    _2015年から2020年の総人口増加数 > 0
ORDER BY
    "人口増加率" DESC, "都道府県コード"
;