SELECT
    T1.PF_CODE AS 都道府県コード,
    T1.PF_NAME AS 都道府県名,
    T1.TOTAL_AMT AS 総人口2015年,
    T2.TOTAL_AMT AS 総人口2020年,
    ROUND(100*(1.0*T2.TOTAL_AMT)/(1.0*T1.TOTAL_AMT)) AS 人口増加率
    FROM
        (SELECT
            POPU_TRANSITION.PF_CODE,
            POPU_TRANSITION.TOTAL_AMT,
            PREFECTURE.PF_NAME
            FROM 
                POPU_TRANSITION
            JOIN PREFECTURE
            ON POPU_TRANSITION.PF_CODE == PREFECTURE.PF_CODE
        WHERE POPU_TRANSITION.SURVEY_YEAR == 2015) T1
    LEFT JOIN
        (SELECT
            POPU_TRANSITION.PF_CODE,
            POPU_TRANSITION.TOTAL_AMT,
            PREFECTURE.PF_NAME
            FROM
                POPU_TRANSITION
            JOIN PREFECTURE
            ON POPU_TRANSITION.PF_CODE == PREFECTURE.PF_CODE
        WHERE POPU_TRANSITION.SURVEY_YEAR == 2020) T2 
    ON T1.PF_CODE == T2.PF_CODE
WHERE T2.TOTAL_AMT > T1.TOTAL_AMT
ORDER BY 人口増加率 DESC, T1.PF_CODE ASC