select 
    PT2015.PF_CODE as "都道府県コード"
    , PF.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 
    POPU_TRANSITION as PT2015
    inner join POPU_TRANSITION as PT2020
        on
            PT2015.PF_CODE = PT2020.PF_CODE
        and
            PT2020.SURVEY_YEAR = 2020
        and
            PT2015.SURVEY_YEAR = 2015
    inner join PREFECTURE as PF
        on
            PT2015.PF_CODE = PF.PF_CODE
    where
        PT2015.TOTAL_AMT <= PT2020.TOTAL_AMT
    order by
        人口増加率 DESC
        , 都道府県コード ASC;