select
    p.PF_CODE as "都道府県コード",
    p.PF_NAME as "都道府県名",
    p2015.TOTAL_AMT as "総人口2015年",
    p2020.TOTAL_AMT as "総人口2020年",
    round( 100 * p2020.TOTAL_AMT / p2015.TOTAL_AMT , 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
    round( 100 * p2020.TOTAL_AMT/p2015.TOTAL_AMT , 0) > 100
order by
    人工増加率 desc,
    p.PF_CODE