select pre.pf_code as 都道府県コード,
pre.pf_name as 都道府県名,
po2015.total_amt as 総人口2015年,
po2020.total_amt as 総人口2020年,
round( cast(po2020.total_amt as real)/(cast(po2015.total_amt as real))*100) as 人口増加率
from PREFECTURE pre
inner join POPU_TRANSITION as PO2015 on pre.pf_code = PO2015.pf_code
inner join POPU_TRANSITION as PO2020 on pre.pf_code = PO2020.pf_code
where
 PO2015.survey_year=2015
 and 
 PO2020.survey_year=2020
 and
 po2015.total_amt < po2020.total_amt
order by 人口増加率 desc,都道府県コード