with x as (
    select *
    from POPU_TRANSITION as t inner join PREFECTURE as p on t.pf_code=p.pf_code
    where SURVEY_YEAR=2015
), y as (
    select *
    from POPU_TRANSITION as t inner join PREFECTURE as p on t.pf_code=p.pf_code
    where SURVEY_YEAR=2020
)
select x.pf_code as 都道府県コード, x.pf_name as 都道府県名,
x.total_amt as 総人口2015年, y.total_amt as 総人口2020年,
round((y.total_amt * 100.0) / x.total_amt) as 人口増加率
from x inner join y on x.PF_CODE=y.PF_CODE
where x.total_amt<y.total_amt
order by 5 desc, 1