with popu2015 as(
    select PF_CODE, TOTAL_AMT as amt2015
    from POPU_TRANSITION
    where SURVEY_YEAR = 2015
), 
    popu2020 as(
    select PF_CODE, TOTAL_AMT as amt2020
    from POPU_TRANSITION
    where SURVEY_YEAR = 2020
)
select 
    p.PF_CODE as '都道府県コード', 
    p.PF_NAME as '都道府県名', 
    p2015.amt2015 as '総人口2015年',
    p2020.amt2020 as '総人口2020年',
    round(100 * (1 + (cast(p2020.amt2020 as real) - cast(p2015.amt2015 as real)) / cast(p2015.amt2015 as real))) as '人口増加率'
from PREFECTURE as p
    inner join popu2015 as p2015 on p.PF_CODE = p2015.PF_CODE
    inner join popu2020 as p2020 on p.PF_CODE = p2020.PF_CODE
where p2015.amt2015 < p2020.amt2020
order by 人口増加率 desc, 都道府県コード asc
;