select p.pf_code as 都道府県コード, p.pf_name as 都道府県名, old_t.TOTAL_AMT as 総人口2015年, t.TOTAL_AMT as 総人口2020年, round(t.TOTAL_AMT*100.0/old_t.TOTAL_AMT, 0) as 人口増加率
from POPU_TRANSITION as t
  join prefecture as p
    on t.pf_code = p.pf_code
  join POPU_TRANSITION as old_t
    on t.pf_code = old_t.pf_code and old_t.SURVEY_YEAR = 2015
where t.SURVEY_YEAR = 2020
order by 人口増加率 desc, 都道府県コード asc