select
    cast(PREFECTURE.PF_CODE as int) as "都道府県コード",
    PF_NAME as "都道府県名",
    Y2015.TOTAL_AMT as "総人口2015年",
    Y2020.TOTAL_AMT as "総人口2020年",
    round(cast(Y2020.TOTAL_AMT as real) / cast(Y2015.TOTAL_AMT as real) * 100.0, 0) as "人口増加率"
from
    POPU_TRANSITION as Y2015
    inner join POPU_TRANSITION as Y2020
        on Y2015.PF_CODE = Y2020.PF_CODE
    inner join PREFECTURE
        on PREFECTURE.PF_CODE = Y2015.PF_CODE
where Y2020.TOTAL_AMT > Y2015.TOTAL_AMT
order by "人口増加率" desc, "都道府県コード" asc;