SELECT
t1.PF_CODE as 都道府県コード,
t2.PF_NAME as 都道府県名,
t2015.total_amt as 総人口2015年,
t1.total_amt as 総人口2020年,
round (((cast(t1.total_amt as real)/t2015.total_amt)*100) , 0) as 人口増加率
from POPU_TRANSITION as t1
left outer join
PREFECTURE as t2
on t1.pf_code = t2.pf_code
left outer join
POPU_TRANSITION as t2015
on t1.pf_code = t2015.pf_code
and t2015.SURVEY_YEAR = '2015'
where t1.SURVEY_YEAR = '2020'
and 総人口2020年 > 総人口2015年
order by 人口増加率 desc , t1.pf_code asc