select
t1.PF_CODE `都道府県コード`,
p.PF_NAME `都道府県名`,
t1.TOTAL_AMT `総人口2015年`,
t2.TOTAL_AMT `総人口2020年`,
round(cast(t2.TOTAL_AMT as real) / t1.TOTAL_AMT * 100, 0) `人口増加率`

from POPU_TRANSITION t1

join POPU_TRANSITION t2
on t1.PF_CODE = t2.PF_CODE
and t2.SURVEY_YEAR = 2020

join PREFECTURE p
on t1.PF_CODE = p.PF_CODE

where
t1.SURVEY_YEAR = 2015
and t2.TOTAL_AMT > t1.TOTAL_AMT

order by
`人口増加率` desc,
`都道府県コード`