select pt.pf_code as 都道府県コード,
    pf_name as 都道府県名,
    pt.total_amt as 総人口2015年,
    pt2020.total_amt as 総人口2020年,
    round(cast(pt2020.total_amt as real)/cast(pt.total_amt as real)*100,0) as 人口増加率
from popu_transition as pt
left outer join prefecture as p
on pt.pf_code = p.pf_code
left outer join popu_transition as pt2020
on pt2020.pf_code = pt.pf_code and pt2020.survey_year = 2020
where pt.survey_year = 2015 and pt2020.total_amt >= pt.total_amt
order by 人口増加率 desc,都道府県コード asc;