with 
po2015 as(
    select *
    from POPU_TRANSITION
    where
        SURVEY_YEAR = 2015

),
po2020 as(
    select *
    from POPU_TRANSITION
    where
        SURVEY_YEAR = 2020

)
select
    po2015.PF_CODE as 都道府県コード	
    ,pr.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 po2015 
left join po2020
on po2015.PF_CODE = po2020.PF_CODE
left join PREFECTURE as pr
on po2015.PF_CODE = pr.PF_CODE
where po2015.TOTAL_AMT < po2020.TOTAL_AMT
order by 人口増加率 desc,
        po2015.PF_CODE asc
;