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