with a(PF_CODE, TOTAL_AMT) as (
select PF_CODE, TOTAL_AMT 
from POPU_TRANSITION
where SURVEY_YEAR==2015
),
b(PF_CODE, TOTAL_AMT) as (
select PF_CODE, TOTAL_AMT 
from POPU_TRANSITION
where SURVEY_YEAR==2020
)
select 
PREFECTURE.PF_CODE, PREFECTURE.PF_NAME, a.TOTAL_AMT as "総人口2015年", b.TOTAL_AMT as "総人口2020年",
round(cast(a.TOTAL_AMT as REAL) / cast(b.TOTAL_AMT as REAL)*100) as "人口増加率"
from PREFECTURE
inner join a
on PREFECTURE.PF_CODE == a.PF_CODE
inner join b
on PREFECTURE.PF_CODE == b.PF_CODE
where cast(a.TOTAL_AMT as REAL) / cast(b.TOTAL_AMT as REAL)*100 >= 100
order by round(cast(a.TOTAL_AMT as REAL) / cast(b.TOTAL_AMT as REAL)*100) desc, PREFECTURE.PF_CODE