with RECURSIVE data_2020(PF_CODE, PF_NAME, TOTAL_AMT) as
(
    select po.PF_CODE, pr.PF_NAME, po.TOTAL_AMT
    from POPU_TRANSITION as po
    left join
        PREFECTURE as pr
        on po.PF_CODE = pr.PF_CODE
    where po.SURVEY_YEAR = 2020
),
data_2015(PF_CODE, TOTAL_AMT) as
(
    select PF_CODE, TOTAL_AMT
    from POPU_TRANSITION as po
    where po.SURVEY_YEAR = 2015
)
    
select data_2020.PF_CODE as 都道府県コード, data_2020.PF_NAME as 都道府県名, data_2015.TOTAL_AMT as 総人口2015年, data_2020.TOTAL_AMT as 総人口2020年, round(cast(data_2020.TOTAL_AMT as real) * 100 / cast(data_2015.TOTAL_AMT as real)) as 人口増加率
from data_2020
left join
    data_2015
    on data_2020.PF_CODE = data_2015.PF_CODE
where 総人口2015年 < 総人口2020年
order by 人口増加率 desc, 都道府県コード asc