select
    T2020.PF_CODE   as "都道府県コード"
   ,T3.PF_NAME      as "都道府県名"
   ,T2015.TOTAL_AMT as "総人口2015年"
   ,T2020.TOTAL_AMT as "総人口2020年"
   ,ROUND(
        CAST(T2020.TOTAL_AMT as real) / 
        CAST(T2015.TOTAL_AMT as real) *
        100
    ) as "人口増加率"
from
    (select
         *
     from
         POPU_TRANSITION
     where
         SURVEY_YEAR = 2020
    )               T2020
left join
    POPU_TRANSITION T2015
on  T2015.SURVEY_YEAR = 2015
and T2015.PF_CODE = T2020.PF_CODE
left join
    PREFECTURE      T3
on  T3.PF_CODE = T2020.PF_CODE
where
    T2020.TOTAL_AMT > T2015.TOTAL_AMT
order by
    "人口増加率" desc
   ,"都道府県コード"