with org as (
select
	*
	, lag(TOTAL_AMT,1) over (partition by PF_CODE order by SURVEY_YEAR) as TOTAL_AMT_2015
	, TOTAL_AMT - lag(TOTAL_AMT,1) over (partition by PF_CODE order by SURVEY_YEAR) as INCREASE_RATE
from POPU_TRANSITION
where SURVEY_YEAR != 2010
)
select
    a.PF_CODE as 都道府県コード
    , b.PF_NAME as 都道府県名
    , a.TOTAL_AMT_2015 as 総人口2015年
    , a.TOTAL_AMT as 総人口2020年
    , round(cast(a.TOTAL_AMT as real)/a.TOTAL_AMT_2015*100,0) as 人口増加率
from org a
inner join PREFECTURE b
    on a.PF_CODE = b.PF_CODE
where INCREASE_RATE is not null
    and INCREASE_RATE > 0
order by 5 desc, 1