WITH tmp as(
    SELECT
        curr.PF_CODE as "都道府県コード",
        prev.TOTAL_AMT as "総人口2015年",
        curr.TOTAL_AMT as "総人口2020年",
        ROUND(cast(curr.TOTAL_AMT as real) / prev.TOTAL_AMT * 100, 0) as "人口増加率"
    FROM POPU_TRANSITION as curr
    INNER JOIN POPU_TRANSITION as prev
    ON 
        curr.PF_CODE = prev.PF_CODE
        and
        curr.SURVEY_YEAR -5 = prev.SURVEY_YEAR
    WHERE
        curr.TOTAL_AMT - prev.TOTAL_AMT > 0
)
SELECT
    tmp."都道府県コード",
    p.PF_NAME as "都道府県名",
    tmp."総人口2015年",
    tmp."総人口2020年",
    tmp."人口増加率"
FROM
    tmp
INNER JOIN PREFECTURE as p
on tmp."都道府県コード" = p.PF_CODE
ORDER BY
    tmp."人口増加率" DESC,
    tmp."都道府県コード"
;