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