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