select PRF.PF_CODE as "都道府県コード",	PRF.PF_NAME as "都道府県名", POP1.TOTAL_AMT as "総人口2015年", POP2.TOTAL_AMT as "総人口2020年", round(cast(POP2.TOTAL_AMT as REAL)*100/cast(POP1.TOTAL_AMT as REAL)) as "人口増加率"
from POPU_TRANSITION as POP1 inner join POPU_TRANSITION as POP2 on POP1.PF_CODE = POP2.PF_CODE inner join PREFECTURE as PRF on POP1.PF_CODE = PRF.PF_CODE
where POP1.SURVEY_YEAR = 2015 and POP2.SURVEY_YEAR = 2020 and "総人口2015年" < "総人口2020年" order by "人口増加率" desc, "都道府県コード" asc