select distinct
    a.PF_CODE as 都道府県コード,
    b.PF_NAME as 都道府県名,
    c.TOTAL_AMT as 総人口2015年,
    d.TOTAL_AMT as 総人口2020年,
    round(cast(d.TOTAL_AMT as REAL)*100/cast(c.TOTAL_AMT as REAL),0) as 人口増加率
from POPU_TRANSITION a
    inner join PREFECTURE b
    on a.PF_CODE=b.PF_CODE
    inner join (select pf_code,TOTAL_AMT from POPU_TRANSITION where SURVEY_YEAR=2015) c
    on a.pf_code=c.pf_code
    inner join (select pf_code,TOTAL_AMT from POPU_TRANSITION where SURVEY_YEAR=2020) d
    on a.pf_code=d.pf_code
where 人口増加率 >= 100
order by 人口増加率 desc, 都道府県コード asc;