SELECT 
    pref.PF_CODE AS テスト,
    pref.PF_NAME AS 都道府県名,
    tran2015.TOTAL_AMT AS 総人口2015年,
    tran2020.TOTAL_AMT AS 総人口2020年,
    round(cast(tran2020.TOTAL_AMT as real) * 100 / cast(tran2015.TOTAL_AMT as real), 0) as 人口増加率
FROM
    PREFECTURE AS pref
        JOIN
    (SELECT 
        *
    FROM
        POPU_TRANSITION
    WHERE
        survey_year = 2015) AS tran2015 ON pref.PF_CODE = tran2015.PF_CODE
        JOIN
    (SELECT 
        *
    FROM
        POPU_TRANSITION
    WHERE
        survey_year = 2020) AS tran2020 ON pref.PF_CODE = tran2020.PF_CODE
where 総人口2020年 > 総人口2015年
ORDER BY 人口増加率 DESC , テスト ASC