SELECT 
     P.PF_CODE AS 都道府県コード
    ,P.PF_NAME AS 都道府県名
    ,P_2015.TOTAL_AMT  AS 総人口2015年
    ,P_2020.TOTAL_AMT  AS 総人口2020年
    ,ROUND(1.0 * P_2020.TOTAL_AMT / P_2015.TOTAL_AMT * 100.0) AS 人口増加率
FROM
PREFECTURE P
INNER JOIN
    (
        SELECT 
             PF_CODE 
            ,SURVEY_YEAR
            ,TOTAL_AMT
        FROM
             POPU_TRANSITION
        WHERE
            SURVEY_YEAR = 2015
    ) AS P_2015
ON P.PF_CODE = P_2015.PF_CODE
INNER JOIN
(
        SELECT 
             PF_CODE 
            ,SURVEY_YEAR
            ,TOTAL_AMT
        FROM
             POPU_TRANSITION
        WHERE
            SURVEY_YEAR = 2020
) P_2020
ON 
    P.PF_CODE = P_2020.PF_CODE
WHERE
    P_2015.TOTAL_AMT < P_2020.TOTAL_AMT
ORDER BY
     人口増加率 DESC
    ,都道府県コード
;