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