with t2015 as 
(
    select 
        SURVEY_YEAR, PF_CODE,  TOTAL_AMT
        from POPU_TRANSITION
        where SURVEY_YEAR=2015
)
, t2020 as  
(
    select 
        SURVEY_YEAR, PF_CODE,  TOTAL_AMT
        from POPU_TRANSITION
        where SURVEY_YEAR=2020
)
, t_merge as
(
    select
        s0.PF_CODE, 
        s0.TOTAL_AMT as "総人口2015年", 
        s1.TOTAL_AMT as "総人口2020年", 
        round((s1.TOTAL_AMT*1.0)/(s0.TOTAL_AMT*1.0)*100.0, 0) as "人口増加率"
        from t2015 as s0
        inner join t2020 as s1
        on s0.PF_CODE=s1.PF_CODE
)
, t_out as 
(
    select 
        a0.PF_CODE as "都道府県コード", PF_NAME as "都道府県名", 
        "総人口2015年", "総人口2020年", "人口増加率"
        from t_merge as a0
        left join PREFECTURE as a1
        on a0.PF_CODE=a1.PF_CODE
)
select * from t_out
    where "総人口2015年"<"総人口2020年"
    order by "人口増加率" desc, "都道府県コード" asc