select T15.PF_CODE AS 都道府県コード
    , PF_NAME AS 都道府県名
    , T15.TOTAL_AMT AS 総人口2015年
    , T20.TOTAL_AMT AS 総人口2020年
    , ROUND(100*CAST(T20.TOTAL_AMT AS REAL)/CAST(T15.TOTAL_AMT AS REAL)) AS 人口増加率
from (
    select PF_CODE, TOTAL_AMT
    from POPU_TRANSITION
    where SURVEY_YEAR = "2015"
    ) AS T15
inner join (
    select PF_CODE, TOTAL_AMT
    from POPU_TRANSITION
    where SURVEY_YEAR = "2020"
    ) AS T20
ON T15.PF_CODE = T20.PF_CODE
inner join PREFECTURE AS B
on T15.PF_CODE = B.PF_CODE
where T20.TOTAL_AMT >= T15.TOTAL_AMT
order by 人口増加率 desc, 都道府県コード asc;