select POPU2015.PF_CODE as 都道府県コード
     , PF.PF_NAME as 都道府県名
     , CAST(POPU2015.TOTAL_AMT as real) as 総人口2015年
     , CAST(POPU2020.TOTAL_AMT as real) as 総人口2020年
     , round(CAST(POPU2020.TOTAL_AMT as real)/CAST(POPU2015.TOTAL_AMT as real) * 100, 0) as 人口増加率
from POPU_TRANSITION as POPU2015
inner join POPU_TRANSITION as POPU2020
        on POPU2015.PF_CODE = POPU2020.PF_CODE
inner join PREFECTURE as PF
        on POPU2015.PF_CODE = PF.PF_CODE
where POPU2015.SURVEY_YEAR = 2015
and   POPU2020.SURVEY_YEAR = 2020
and   CAST(POPU2015.TOTAL_AMT as real) < CAST(POPU2020.TOTAL_AMT as real)
order by 5 desc, 1 asc