select
    PT15.PF_CODE as `都道府県コード`
    , P.PF_NAME as `都道府県名`
    , PT15.TOTAL_AMT as `総人口2015年`
    , PT20.TOTAL_AMT as `総人口2020年`
    , Round(CAST(PT20.TOTAL_AMT as REAL) / CAST(PT15.TOTAL_AMT as REAL) * 100, 0) as `人口増加率`
from
    (
    select
        PF_CODE
        , TOTAL_AMT
    from
        POPU_TRANSITION
    where
        SURVEY_YEAR = 2015
    ) as PT15
inner join
    (
    select
        PF_CODE
        , TOTAL_AMT
    from
        POPU_TRANSITION
    where
        SURVEY_YEAR = 2020
    ) as PT20 on PT20.PF_CODE = PT15.PF_CODE
inner join
    PREFECTURE P on P.PF_CODE = PT15.PF_CODE
where
    PT20.TOTAL_AMT > PT15.TOTAL_AMT
order by
    PT20.TOTAL_AMT - PT15.TOTAL_AMT DESC
    , PT15.PF_CODE ASC
;