with p2015 as (
    select PF_CODE as "pfc",
            TOTAL_AMT as "ta2015"
    from POPU_TRANSITION
    where SURVEY_YEAR = 2015
    ),

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