select 
    pt.PF_CODE as '都道府県コード',
    pr.PF_NAME as '都道府県名',
    pt.TOTAL_AMT as '総人口2015年',
    pt20.TOTAL_AMT as '総人口2020年',
    round(cast(pt20.TOTAL_AMT as real)/cast(pt.TOTAL_AMT as real) * 100) as '人口増加率'
from POPU_TRANSITION as pt
    inner join PREFECTURE as pr on pt.PF_CODE = pr.PF_CODE
    inner join POPU_TRANSITION as pt20 on pt.PF_CODE = pt20.PF_CODE and pt20.SURVEY_YEAR = 2020
where pt.SURVEY_YEAR = 2015 and  pt20.TOTAL_AMT > pt.TOTAL_AMT
order by 人口増加率 desc,
         pt.PF_CODE asc;