select
p.PF_CODE as "都道府県コード"
,p.PF_NAME as "都道府県名"
,p_2015.TOTAL_AMT as "総人口2015年"
,p_2020.TOTAL_AMT as "総人口2020年"
,round(cast((p_2020.TOTAL_AMT - p_2015.TOTAL_AMT) as real) / cast(p_2015.TOTAL_AMT as real) * 100) as "人口増加率"
from POPU_TRANSITION p_2015
inner join POPU_TRANSITION p_2020 on p_2015.PF_CODE = p_2020.PF_CODE
inner join PREFECTURE p on p.PF_CODE = p_2015.PF_CODE
where p_2020.SURVEY_YEAR = 2020
  and p_2015.SURVEY_YEAR = 2015
  and p_2020.TOTAL_AMT > p_2015.TOTAL_AMT
order by "人口増加率" desc, p.PF_CODE asc
;