with p2015 as (
    select PF_CODE as "pfc",
            cast(TOTAL_AMT as real) as "ta2015"
    from POPU_TRANSITION
    where SURVEY_YEAR = 2015
    ),
    p2020 as (
    select PF_CODE as "pfc",
            cast(TOTAL_AMT as real) as "ta2020"
    from POPU_TRANSITION
    where SURVEY_YEAR = 2020
    )
    
select pfc as "都道府県コード",
        PF_NAME as "都道府県名",
        ta2015 as "総人口2015年",
        ta2020 as "総人口2020年",
        round(ta2020 * 100 / ta2015 ,0) as "人口増加率"
from p2015
    inner join
    p2020
    using(pfc)
    inner join
    PREFECTURE p
    ON pfc = p.PF_CODE
where ta2015 < ta2020
order by 5 desc, 1 asc
;