select
    PT.PF_CODE AS "都道府県コード"
    ,PR.PF_NAME AS "都道府県名"
    ,PT.TOTAL_AMT AS "総人口2015年"
    ,PT2020.TOTAL_AMT AS "総人口2020年"
    ,ROUND (
    CAST(PT2020.TOTAL_AMT as real) / CAST (PT.TOTAL_AMT as real)
    * 100
    , 0)
    AS "人口増加率"


from
    POPU_TRANSITION PT
    inner join  PREFECTURE PR
    ON PT.PF_CODE = PR.PF_CODE
    
    INNER JOIN POPU_TRANSITION PT2020
    ON PT2020.PF_CODE = PT.PF_CODE
    and PT2020.SURVEY_YEAR = 2020
    
where
    PT.SURVEY_YEAR = 2015
    AND PT2020.TOTAL_AMT >= PT.TOTAL_AMT
    
order By
    人口増加率 desc
    , 都道府県コード asc
    ;