select t1.PF_CODE as `都道府県コード`,
    t3.PF_NAME as ` 都道府県名`,
    t1.TOTAL_AMT as `総人口2015年`,
    t2.TOTAL_AMT as `総人口2020年`,
    round(
        cast(t2.TOTAL_AMT as REAL) / cast(t1.TOTAL_AMT as REAL) * 100
    ) as `人口増加率`
from POPU_TRANSITION t1
    inner JOIN POPU_TRANSITION t2 on t1.PF_CODE = t2.PF_CODE AND t2.SURVEY_YEAR = 2020
    inner join PREFECTURE t3 on t1.PF_CODE = t3.PF_CODE
where t1.SURVEY_YEAR = 2015
    and t2.TOTAL_AMT >= t1.TOTAL_AMT
order by `人口増加率` desc, `都道府県コード` asc;