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

from POPU_TRANSITION as A

inner join PREFECTURE on  PREFECTURE.PF_CODE = A.PF_CODE
inner join (

select PF_CODE, TOTAL_AMT
from POPU_TRANSITION
where SURVEY_YEAR = 2020

) as B
on A.PF_CODE = B.PF_CODE

where SURVEY_YEAR = 2015 and "総人口2015年" < "総人口2020年"

order by "人口増加率" desc, 1 asc;