with y2015 as (
select
PF_CODE
,TOTAL_AMT
from POPU_TRANSITION
where SURVEY_YEAR = 2015
)
,y2020 as (
select
PF_CODE
,TOTAL_AMT
from POPU_TRANSITION
where SURVEY_YEAR = 2020
)
select
PREFECTURE.PF_CODE as '都道府県コード'		
,PREFECTURE.PF_NAME as '都道府県名'
,y2015.TOTAL_AMT as '総人口2015年'
,y2020.TOTAL_AMT as '総人口2020年'
,round(y2020.TOTAL_AMT * 100.0 / y2015.TOTAL_AMT)  as '人口増加率'
from y2020
left join y2015 on y2020.PF_CODE = y2015.PF_CODE
left join PREFECTURE on PREFECTURE.PF_CODE = y2020.PF_CODE
where y2015.TOTAL_AMT < y2020.TOTAL_AMT
order by y2020.TOTAL_AMT * 1.0 / y2015.TOTAL_AMT desc, PREFECTURE.PF_CODE