select
    p.PF_CODE as "都道府県コード",
    p.PF_NAME as "都道府県名",
    p2015.TOTAL_AMT as "総人口2015年",
    p2020.TOTAL_AMT as "総人口2020年",
    round( 100 * cast(p2020.TOTAL_AMT as real) / cast(p2015.TOTAL_AMT as real) , 0)  as "人口増加率"
from
    POPU_TRANSITION as p2015
join
    POPU_TRANSITION as p2020 on p2015.PF_CODE = p2020.PF_CODE and p2020.SURVEY_YEAR = 2020
join
    PREFECTURE as p on p2015.PF_CODE = p.PF_CODE
where
    p2015.SURVEY_YEAR = 2015
and
    P2020.TOTAL_AMT >= P2015.TOTAL_AMT
order by
    人口増加率 desc,
    p.PF_CODE asc