with t2015 as (
    select PF_CODE, TOTAL_AMT from POPU_TRANSITION
    where SURVEY_YEAR = 2015
), t2020 as (
    select PF_CODE, TOTAL_AMT from POPU_TRANSITION
    where SURVEY_YEAR = 2020
)
select PF_CODE as 都道府県コード
, PF_NAME as 都道府県名
, t2015.TOTAL_AMT as 総人口2015年
, t2020.TOTAL_AMT as 総人口2020年
, round(cast(t2020.TOTAL_AMT as real) / cast(t2015.TOTAL_AMT as real) * 100, 0) as 人口増加率
from PREFECTURE
join t2015
using (PF_CODE)
join t2020
using (PF_CODE)
where cast(t2020.TOTAL_AMT as real) / cast(t2015.TOTAL_AMT as real) > 1.0
order by 人口増加率 desc, 都道府県コード