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