SELECT
    t2015.PF_code as 都道府県コード
    ,m.pf_name as 都道府県名
    ,t2015.TOTAL_AMT as 総人口2015年
    ,t2020.TOTAL_AMT as 総人口2020年
    ,round((cast(t2020.TOTAL_AMT as real) / cast(t2015.TOTAL_AMT as real) )*100 , 0) as 人口増加率
FROM (
    select
        t1.PF_code
        ,t1.TOTAL_AMT
    FROM POPU_TRANSITION t1
    where 1 = 1
        and t1.SURVEY_YEAR = 2015
    ) t2015
INNER JOIN (
    select
        t1.PF_code
        ,t1.TOTAL_AMT
    FROM POPU_TRANSITION t1
    where 1 = 1
        and t1.SURVEY_YEAR = 2020
    ) t2020
    ON t2015.PF_code = t2020.PF_code
INNER JOIN PREFECTURE m
    ON m.PF_code = t2020.PF_code
where 1 = 1
    and t2020.TOTAL_AMT > t2015.TOTAL_AMT 
order by 
    人口増加率 DESC
    ,都道府県コード ASC