select
    pt1.PF_CODE as 都道府県コード,
    pr.pf_name as 都道府県名,
    pt1.total_amt as 総人口2015年,
    pt2.total_amt as 総人口2020年,
    round(pt2.total_amt * 100.0 / pt1.total_amt) as 人口増加率
from
    POPU_TRANSITION as pt1
    inner join POPU_TRANSITION as pt2 on pt2.pf_code=pt1.pf_code and pt2.survey_year=2020
    inner join PREFECTURE as pr on pt1.pf_code=pr.pf_code
where
    pt1.survey_year=2015 and
    pt1.total_amt<=pt2.total_amt
order by
    人口増加率 desc,
    都道府県コード
;