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