SELECT
pr.PF_CODE AS 都道府県コード,
pr.PF_NAME AS 都道府県名,
po.T2015 AS 総人口2015年,
po.T2020 AS 総人口2020年,
ROUND(cast(po.T2020 as real) * 100 / po.T2015) AS 人口増加率
FROM
PREFECTURE AS pr
INNER JOIN
(
    SELECT
    t1.PF_CODE AS PF_CODE,
    t1.TOTAL_AMT AS T2015,
    t2.TOTAL_AMT AS T2020
    FROM
    POPU_TRANSITION as t1
    INNER JOIN
    (
        SELECT
        PF_CODE,
        TOTAL_AMT
        FROM 
        POPU_TRANSITION
        WHERE
        SURVEY_YEAR = 2020
    ) as t2
    ON
    t1.PF_CODE = t2.PF_CODE
    WHERE t1.SURVEY_YEAR = 2015
) as po
ON 
pr.PF_CODE = po.PF_CODE
ORDER BY
人口増加率 DESC, 都道府県コード