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