select
    pr.PF_CODE as "都道府県コード"
    ,pr.PF_NAME as "都道府県名"
    ,pt.TOTAL_AMT as "総人口2015年"
    ,pt2020.TOTAL_AMT as "総人口2020年"
    ,round(cast(pt2020.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 pt2020
on pt.PF_CODE = pt2020.PF_CODE and pt2020.SURVEY_YEAR = 2020
where pt.SURVEY_YEAR = 2015 and pt2020.SURVEY_YEAR > pt.SURVEY_YEAR
order by "人口増加率" desc, pr.PF_CODE asc