select t1.PF_CODE as 都道府県コード,
    t3.PF_NAME as 都道府県名,
    t1.TOTAL_AMT as 総人口2015年,
    t2.TOTAL_AMT as 総人口2020年,
    round(
        cast(t2.TOTAL_AMT as REAL) / cast(t1.TOTAL_AMT as REAL) * 100
    ) as 人口増加率
from (
        select PF_CODE,
            TOTAL_AMT
        from POPU_TRANSITION
        where SURVEY_YEAR = 2015
    ) t1
    join (
        select PF_CODE,
            TOTAL_AMT
        from POPU_TRANSITION
        where SURVEY_YEAR = 2020
    ) t2 on t1.PF_CODE = t2.PF_CODE
    join PREFECTURE t3 on t1.PF_CODE = t3.PF_CODE
where t2.TOTAL_AMT > t1.TOTAL_AMT
order by 人口増加率 desc,
    都道府県コード