select a.PF_CODE as "都道府県コード", PF_NAME as "都道府県名", AMT15 as "総人口2015年", AMT20 as "総人口2020年", round(cast(AMT20 as REAL)/cast(AMT15 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(AMT20 as REAL)/cast(AMT15 as REAL)*100) DESC, a.PF_CODE ASC