select
    P.PF_CODE as 都道府県コード
    , P.PF_NAME as 都道府県名
    , PT_2015.TOTAL_AMT as 総人口2015年
    , PT_2020.TOTAL_AMT as 総人口2020年
    , round(PT_2020.TOTAL_AMT * 100 / PT_2015.TOTAL_AMT) as 人口増加率
from
    PREFECTURE as P
join POPU_TRANSITION as PT_2015 on PT_2015.SURVEY_YEAR = 2015 and PT_2015.PF_CODE = P.PF_CODE
join POPU_TRANSITION as PT_2020 on PT_2020.SURVEY_YEAR = 2020 and PT_2020.PF_CODE = P.PF_CODE
where 人口増加率 > 100
order by 5 desc, 1