select a.PF_CODE as "都道府県コード", PF_NAME as "都道府県名", AMT15 as "総人口2015年", AMT20 as "総人口2020年", round(cast(AMT15 as REAL)/cast(AMT20 as REAL)*100) as "人口増加率"
from (
    select *
    from (select PF_CODE, TOTAL_AMT as AMT15 from POPU_TRANSITION where SURVEY_YEAR = 2015) as amt15
    join (select PF_CODE, TOTAL_AMT as AMT20 from POPU_TRANSITION where SURVEY_YEAR = 2020) as amt20
    on amt15.PF_CODE = amt20.PF_CODE
    ) as a
join PREFECTURE p
on p.PF_CODE = a.PF_CODE
order by round(cast(AMT15 as REAL)/cast(AMT20 as REAL)*100) DESC, a.PF_CODE ASC

/*PF_CODE → 都道府県コード
PF_NAME → 都道府県名
2015年のTOTAL_AMT → 総人口2015年
2020年のTOTAL_AMT → 総人口2020年
人口増加率を%で表示(小数点以下は四捨五入) → 人口増加率
表示順

人口増加率の降順
都道府県コードの昇順*/