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