select pt15.PF_CODE as '都道府県コード', pf.PF_NAME as '都道府県名', 
 pt15.TOTAL_AMT as '総人口2015年', pt20.TOTAL_AMT as '総人口2020年', 
 round((pt20.TOTAL_AMT*100+0.0)/(pt15.TOTAL_AMT+0.0),0) as '人口増加率'
from POPU_TRANSITION as pt15 
 left join PREFECTURE as pf on pt15.PF_CODE=pf.PF_CODE 
 left join POPU_TRANSITION as pt20 on pt15.PF_CODE=pt20.PF_CODE and pt20.SURVEY_YEAR=2020 
where pt15.SURVEY_YEAR=2015 and pt15.TOTAL_AMT<pt20.TOTAL_AMT 
order by round((pt20.TOTAL_AMT*100+0.0)/(pt15.TOTAL_AMT+0.0),0) desc, pt15.PF_CODE asc
;