SELECT pop.PF_CODE as "都道府県コード", pre.PF_NAME as "都道府県名", pop.TOTAL_AMT as "総人口2015年", pop2020.TOTAL_AMT as "総人口2020年", round(cast(pop2020.TOTAL_AMT as real)/cast(pop.TOTAL_AMT as real)*100) as "人口増加率"
from POPU_TRANSITION as pop
join PREFECTURE as pre
on pre.PF_CODE  = pop.PF_CODE
join POPU_TRANSITION as pop2020
on pop2020.PF_CODE = pop.PF_CODE and pop2020.SURVEY_YEAR = 2020
where pop.SURVEY_YEAR = 2015
order by "人口増加率" desc