with POPU_2015 as (
    select PF_CODE , TOTAL_AMT P_2015
    from POPU_TRANSITION
    where SURVEY_YEAR = 2015
)
, POPU_2020 as (
    select PF_CODE , TOTAL_AMT P_2020
    from POPU_TRANSITION
    where SURVEY_YEAR = 2020
)
select A.PF_CODE as '都道府県コード'
    , ( select C.PF_NAME from PREFECTURE  C where C.PF_CODE = A.PF_CODE ) as '都道府県名'
    , A.P_2015 as '総人口2015年'
    , B.P_2020 as '総人口2020年'
    , round( CAST(B.P_2020 as real ) / CAST(A.P_2015 as real )  * 100 ) as 人口増加率
from POPU_2015 A , POPU_2020 B
where A.PF_CODE = B.PF_code 
    and B.P_2020 > A.P_2015 
order by 5 desc , 1